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 · answered Mar 30 '11 at 16:59

8

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

Such as:

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

answered Mar 30 '11 at 16:59

Majenko

32,128
4
61
81

thanks for ODBC keyword. I'm as yet unable to get sqliteodbc to work, *"The specified DSN contains an architecture mismatch between the Driver and Application (#0)"*, but at least now I have a path to follow. – matt wilkie Mar 30 '11 at 18:42
@mattwilkie Were you able to get this working? – Forethinker May 22 '13 at 04:44
@Forethinker, yes, though the details are lost in time and I've not used the connection for quite awhile. It was through reading and testing the linke above though. – matt wilkie May 22 '13 at 17:41
3

For people finding this through Google, I had the mismatch architecture problem when the sqliteodbc version was a different architecture (32bit vs 64bit) to MS Office, not to the OS it's installed on. ie installing 64bit ODBC on 64bit windows won't work with 32bit Office. – Holloway Jan 29 '15 at 12:20

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

2,984
6
40
55

Open SQLite db in Microsoft Access?

3 Answers3

Linked