Open SQLite db in Microsoft Access?
Are there any tools to allow using sqlite databases from Microsoft Access?
Of course full access is preferred, being able to edit records, add tables & fields, etc. but read-only browsing would helpful too.
I'm using Access 2007 x64.
Solution 1:
What you want is an ODBC driver for SQLite...
Such as:
- http://www.ch-werner.de/sqliteodbc/
- http://www.patthoyts.tk/sqlite3odbc.html
Just googling for "SQLite ODBC" returns a heap of results that can help you.