CODEWITHSUNDEEP
databasems-accessvbasqliteimport
Phong
Phong

Reputation: 6768

How to use SQLite database from MS Access?

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

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

Upvotes: 11

Views: 30752

Answers (4)

Jason
Jason

Reputation: 2597

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

Upvotes: 8

HansUp
HansUp

Reputation: 97101

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.

Upvotes: 4

Samuel Neff
Samuel Neff

Reputation: 74909

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.

Upvotes: 2

Craig T
Craig T

Reputation: 2742

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

Upvotes: 1

Related Questions