How to use SQLite database from MS Access?

Question

I would like to use an SQLite database from Microsoft Access (access from- or transfer the contents to Microsoft Access).

• How can this be done using VBA?

This is for a client who can not install extra software:

• Does a library exist in VBA to use SQLite databases?

Answer 1

This question popped up in my recent (2021) search on the same topic, and the answer has changed since 2010.

There are now several ODBC drivers for SQLite. Here are two (I have no affiliation with either):

Free: http://www.ch-werner.de/sqliteodbc/

Paid: https://www.devart.com/odbc/sqlite/download.html

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.