How to use the sqlite database from MS Access?


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 ?

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.