So how can I use this nice macro? the excel sheet seems to be blank. I'm not sure what this point means: "Examine and run the example test code in the SQLite3Demo module." what should I expect after I "run" the Sqlite3 VBA? I chose AllTests and it seems to execute silently but so what?
Could you please add a very simple example to use this macro to connect to a SQLite database with one table? All I want is to have a drop down list in excel that pulls values from the SQLite table. The XLSQLite.xlam example at http://www.gatekeeperforexcel.com/other-freebies.html seems useful but it only works for 32 bits and I have 64 bits. I dont want the complex GUI part. Just simple.
Thank you
So how can I use this nice macro? the excel sheet seems to be blank. I'm not sure what this point means: "Examine and run the example test code in the SQLite3Demo module." what should I expect after I "run" the Sqlite3 VBA? I chose AllTests and it seems to execute silently but so what? Could you please add a very simple example to use this macro to connect to a SQLite database with one table? All I want is to have a drop down list in excel that pulls values from the SQLite table. The XLSQLite.xlam example at http://www.gatekeeperforexcel.com/other-freebies.html seems useful but it only works for 32 bits and I have 64 bits. I dont want the complex GUI part. Just simple. Thank you