Open SQLite db in Microsoft Access?

Question

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.

score 8 · Accepted Answer · edited Sep 05 '23 at 11:24

8

What you want is an ODBC driver for SQLite...

Such as:

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

Just googling for "SQLite ODBC" returns a heap of results that can help you.

edited Sep 05 '23 at 11:24

Community

1

answered Mar 30 '11 at 16:59

Majenko

32,964

score 0 · Answer 2 · answered Dec 04 '16 at 15:46

Although I'm aware not specifically answering your question, you might also consider Kexi (www.kexi-project.org), which is an Access-like or Framemaker-like software and natively using sqlite. It was initially written for Linux with KDE Destkop, but was compiled to a binary for Windows too (https://forum.kde.org/viewtopic.php?f=221&t=110012) and Kexi's main author is currently paying attention to the native Window port (https://forum.kde.org/viewtopic.php?f=220&t=127422).

score 0 · Answer 3 · answered Mar 30 '11 at 19:30

0

As an alternative to using access, I wrote a SQL browser for access called PlaneDisaster.NET. I also have a tool in there that converts from mdb to sqlite. I never wrote a tool to go the other way, but if you know C# that code is a good start.

answered Mar 30 '11 at 19:30

Justin Dearing

3,114

Open SQLite db in Microsoft Access?

3 Answers3

Linked