search

govert / SQLiteForExcel

A lightweight wrapper to give access to the SQLite3 library from VBA.
MIT License
256 stars 81 forks source link

Support for encrypted databases #13

Open ccastillo579 opened 3 years ago

ccastillo579 commented 3 years ago

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 Cipher). The wrapper can not open these databases. Can you write an instruction that open encrypted databases, with a given password? Parameters of this procedure or function are the DB Handler, the DB username and password. Thanks in advance for your help.

govert commented 3 years ago

The SQLiteForExcel helper does not know about such encrypted databases, and in fact only knows how to translate VBA to the C API of the official SQLite library. The special encryption that your other tool (is it this one https://sqlitebrowser.org/ ) does is not something I am familiar with, or can integrate. You could ask the developers of the other SQLite tool to look at this SQLiteForExcel project. They will understand what is needed, and if they are interested in making their encrypted database available to VBA through the SQLiteForExcel approach, they are welcome to contact me, and perhaps I can advise them on how to do it. But I don't think there is anything I can do directly from my side.