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...
My company recently updated to office 365 and all my tools got vastly slower using this. Specifically running the DLL api functions to step thru the cursor, read the datatype...
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...
