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).

  • 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?

Answers


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.


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.


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


Need Your Help

Xcode snapshot fails when using git lfs

xcode git

I have git set up with the git-lfs extension. When using Xcode 6 to do a search and replace then it uses git internally to take a snapshot of the project before doing the replace. Now that I am usi...

How do I create a dataset with all entries in each row in R?

r formatting dataset subset

Say I have a large dataset, and the information is organized based on a type of entry, and the amount of occurrences of that type of entry.