Is there a replacement for mdbtools?

views:

269

answers:

+3 Q:

Is there a replacement for mdbtools?

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?

+1 A:

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.

Kimvais 2009-09-29 08:00:35

I don't see anything in the question indicating that a different data store is an option. -1

David-W-Fenton 2009-09-30 02:59:52

@ David: Only as a last option if it isn't possible otherwise.

Georg 2009-09-30 08:18:34

+1 A:

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.

Tony Toews 2009-11-24 19:55:16

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.

2010-09-27 16:00:55

Have you used it or did you just find it in a Google search? Or do you work for EasySoft?

David-W-Fenton 2010-09-27 17:57:30

ansaurus

tags:

views:

answers:

Is there a replacement for mdbtools?

related questions