How to use sqlite database from inside MS Access ?

Question

I would like to use a sqlite databse inside MS Access in order to use (transfer would be good enough) the content of sqlite database table in MS-Access.

• How can this be done in VBA ?

EDIT: This "Application" is for a client and I can not make him install "extra software" than the one already installed (in this case MS-Access):

• Does a standard library exist in VBA to used sqlite database ?

Answer 1

There are a number of solutions available which a simple Google search would reveal. Here is one: http://www.freevbcode.com/ShowCode.asp?ID=6893

Answer 2

Does a standard library exist in VBA to used sqlite database?

No. Access and VBA do not have any native capability to connect to SQLite data sources.

You would have to install additional software to allow Access to use SQLite.

Answer 3

If you can use the sqlite3.exe command line tool, then have VBA spawn that and dump the data to a csv file. Then Access can read both local data and the CSV file and copy appropriately.