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.