open access file in python

Question

I am not able to open the access file using python. I am not sure if the problem is with the mdb file or the python commands.

In [1]: import sys, subprocess

In [2]: DATABASE = 'Exam_BackUp.mdb'

In [3]: table_names = subprocess.Popen(["mdb-tables", "-1", DATABASE], stdout=subprocess.PIPE).communicate()[0]
Couldn't open database.

How do I know if the file is microsoft access file? I have checked that mdbtools is installed on my Ubuntu server.

I need to open the (access or fortran) file and save the contents to csv.

You might be interested in my answer to a similar question [here](http://stackoverflow.com/a/25614063/2144390). — Gord Thompson, Nov 06 '14 at 16:36

Timothy Brown · Accepted Answer · 2014-11-06T21:25:27.863

2

Why not try opening it with an ODBC driver?

A good example is here, reproducing it for your case would be along the lines of:

import pyodbc

DBfile = 'Exam_BackUp.mdb'
conn = pyodbc.connect('FILEDSN='+DBfile)
cursor = conn.cursor()

# Do whatever you want with SQL selects, etc

cursor.close()
conn.close()

edited Nov 06 '14 at 21:25

answered Nov 06 '14 at 16:21

Timothy Brown

2,220
18
22

2

Error: ('IM002', '[IM002] [unixODBC][Driver Manager]Data source name not found, and no default driver specified (0) (SQLDriverConnect)') – shantanuo Nov 06 '14 at 16:56
@shantanuo A quick search here found this [solution](http://stackoverflow.com/questions/3251702/how-to-connect-pyodbc-to-an-access-mdb-database-file). – Timothy Brown Nov 06 '14 at 21:22

score 1 · Answer 2 · edited Feb 28 '19 at 15:58

1

You can convert it by the Terminal using mdbtool like this:

Install mdbtools and upgrade it:

pip install mdbtools
pip install --upgrade pip

Then look for the name of the table inside the mdb file:

home/Docs$ mdb-tables 'file.mdb'

And finally convert the file to .csv with this line:

home/Docs$ mdb-export 'file.mdb' 'name_of_table' > 'file.csv'

edited Feb 28 '19 at 15:58

Nikos Tavoularis

2,843
1
30
27

answered Feb 28 '19 at 15:15

DataSSA

11
4

open access file in python

2 Answers2

Linked