Govert van Drimmelen
Govert van Drimmelen
Are you running the SQLiteForExcel_64.xlsm? Did you copy the x64 directory and that version of SQLite3.dll too? On which line does it crash?
I think it might be a problem with the backup API. You can comment out the line calling `TestBackup` inside `Sub AllTests()`. I'll have a look - the declaration of...
I wonder what's wrong though - the declaration looks fine to me, comparing with the documentation here: https://www.sqlite.org/c3ref/backup_finish.html
@arildj78 I've not taken a closer look yet. I'd be interested if you find anything.
@jikosan Cool - thanks for spotting that!
I think you should change the date text to Spanish, for the `DateValue` VBA function to understand it.
Yes - `DateValue` is not so useful. Would you like to make a pull request that changes those to `DateSerial(...)`?
I think the part that is slower in newer Excel versions is some of the COM object model interactions with Excel. So if you are reading or writing cell-by-cell, that...
Have you perhaps moved from 32-bit to 64-bit? Maybe that makes such a difference. I do know anything about the character encoding in the SQLite db - this SQLiteForExcel code...
Storing the data as UTF16 might bloat your SQLite DB, so it's not obvious that there will much of a performance improvement. The only Windows API called for text columns...