SQLiteForExcel
SQLiteForExcel copied to clipboard
govert
A lightweight wrapper to give access to the SQLite3 library from VBA.
I have an error in my spanish excel 
I found that [sqlite.com](https://sqlite.org/) provide an extension file for adding extra function on sqlite, such as SQRT(). This function is really important for my daily operation. But I dont know...
Hi. I want to use the row_number() window function but it is not available on the latest "SQLite for Excel" bundle from 2016 (SQLite 3.11?). Window functions first appeared on...
I use this wrapper in order to upload SQLite data to Excel. For security reasons, SQLite containers that I manage has password now (It was given by SQLite Browser with...
** Issue resolved. It comes down to Trusted Locations. Comment below *** My company recently updated to office 365 and all my tools got vastly slower using this. Specifically running...
From an email suggestion: > I have noted that you have commented the following functions as untested: > sqlite3_stdcall_column_int64 and > sqlite3_stdcall_bind_int64 > > I have successfully managed to use...
If I try to run the "AllTests" method in the example project, excel crashes with the error: "Excel has stopped working". Nothing else? I'm using Excel 2013
I.e. DateValue("1 Jan 2000") doesn't work on machine with Russian locale, for example.
I just tried running the demo routine, and it crashed Excel four out of four times. I stepped through the code, and it crashes on the operative line of the...
Would this still work on the latest vba engine? I know there were some changes to how 64 bit vba needed to use pointers and call windows api functions...
