Is there a replacement for mdbtools?

Question

I'm using mdbtools' SQL functionality to connect to an .mdb file on linux. Mdbtools is still beta and hasn't been updated since 2007, many features like sufficient SQL support aren't available yet.

Features I need:

SQL, either with python bindings or through ODBC.
AS statement in SQL operations.
JOIN if possible.
Runs on non-windows.
Sub-selects would be really handy.
Write support is not necessary.

Is there a replacement for it that is actively being developed?

Highly unlikely. I've never seen any such although I don't know everything about Access. Also write support is highly, highly complex and likely as big a task as everything they've done so far. — Tony Toews, Sep 29 '09 at 20:11
Possible duplicate of [Read an Access database in Python on non-Windows platform (Linux or Mac)](https://stackoverflow.com/q/25596737/2144390) — Gord Thompson, Sep 29 '17 at 12:52

score 7 · Answer 1 · answered May 06 '12 at 18:39

7

MDBtools is again an active project, hosted on github:

https://github.com/brianb/mdbtools

It appears to be 'official', in that the github account hosting the repository was registered by the original author of mdbtools, Brian Bruns.

He is accepting patches, there is an active-ish issue queue, etc.

answered May 06 '12 at 18:39

mikewaters

3,668
3
28
22

1

2020 update: the upstream repo is dead and hasn't seen any recent activity. A maintained fork with many fixes and improvements is available at https://github.com/evanmiller/mdbtools – ndawson Aug 19 '20 at 23:08

score 3 · Answer 2 · answered Sep 29 '09 at 08:00

3

You could use this http://code.google.com/p/mdb-sqlite/ tool to convert the files to SQLite and use your favourite script language to access it.

answered Sep 29 '09 at 08:00

Kimvais

38,306
16
108
142

I don't see anything in the question indicating that a different data store is an option. -1 – David-W-Fenton Sep 30 '09 at 02:59
@ David: Only as a last option if it isn't possible otherwise. – Georg Schölly Sep 30 '09 at 08:18

score 2 · Answer 3 · answered Nov 24 '09 at 19:55

2

A solution I recently came across that maybe of some use. Jackcess is a pure Java library for reading from and writing to MS Access databases.

answered Nov 24 '09 at 19:55

Tony Toews

7,850
1
22
27

score -2 · Answer 4 · answered Sep 27 '10 at 16:00

-2

There is an ODBC Driver for Linux that can read ms-access. http://www.easysoft.com/products/data_access/odbc-access-driver/index.html

and it costs some money.

answered Sep 27 '10 at 16:00

Ura

2,173
3
24
41

4

Have you used it or did you just find it in a Google search? Or do you work for EasySoft? – David-W-Fenton Sep 27 '10 at 17:57

Is there a replacement for mdbtools?

4 Answers4