Is there a replacement for mdbtools?

ms-access mdbtools
Georg Schölly picture Georg Schölly · Sep 29, 2009 · Viewed 6.9k times · Source

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?

Answer

mikewaters picture mikewaters · May 6, 2012

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.

Related questions

mdb-export not creating CSV file

When I run mdb-export, the program dumps the comma delimited table to the terminal, but does not create a csv file as far as I can tell. Is mdb-export creating a csv file somewhere or is this dump its intended …

Read More
Extract and sort data from .mdb file using mdbtools in Python

I'm quite new to Python, so any help will be appreciated. I am trying to extract and sort data from 2000 .mdb files using mdbtools on Linux. So far I was able to just take the .mdb file and dump all …

Read More
How to do INSERT into a table records extracted from another table

I'm trying to write a query that extracts and transforms data from a table and then insert those data into another table. Yes, this is a data warehousing query and I'm doing it in MS Access. So basically I want …

Read More