2

Is there any API in python that can load .mdb file in linux environment and convert them into python friendly data structure like numpy or hdf5?

hpaulj
  • 221,503
  • 14
  • 230
  • 353
thetna
  • 6,903
  • 26
  • 79
  • 113
  • 2
    I think this url will help you. http://stackoverflow.com/questions/3620539/how-to-deal-with-mdb-access-files-with-python – ljdawn Jun 15 '15 at 13:38
  • Tried with this, but this thread does not deal with linux environment. – thetna Jun 15 '15 at 13:39
  • 1
    I'm seeing lots of references to `mdbtools`, and some `py` packages to access that. – hpaulj Jun 15 '15 at 15:55
  • 1
    Also look into `csv` export and conversion to other databases (e.g. `mysql`). Transforming your data into `numpy` arrays (and storing them in `hd5f` format) is a step beyond that. – hpaulj Jun 15 '15 at 16:07

1 Answers1

1

Not sure if there is an open-source Microsoft Access Driver (.mdb).

There is the Easysoft MDB Driver (time limited free evaluation license) which is compatible with unixODBC that you can then use from python with pyodbc (as discussed in this question, mentionned in the comments by @ljdawn ).

Here is a detailed guide that explains how to make this work.

Community
  • 1
  • 1
rth
  • 10,680
  • 7
  • 53
  • 77