How to connect Python to Microsoft Access database file?

Asked Aug 24 '19 at 06:53

Active Aug 24 '19 at 09:16

Viewed 1,493 times

I am trying to connect Python to a Microsoft Access database file, but I keep getting this error:

64bit and Office 365 Business 64bit (Access).

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=[path];')
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)

import pyodbc

conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=[path];')
cursor = conn.cursor()
cursor.execute('select * from username_pw')

for row in cursor.fetchall():
    print (row)

edited Aug 24 '19 at 09:16

user4157124

2,809
13
27
42

asked Aug 24 '19 at 06:53

Bryan Banuelos

Are you running 32bit perhaps ? – Stian Diehard Aug 24 '19 at 09:32
Check the list returned by `pyodbc.drivers()` to see what drivers are available to your Python app. – Gord Thompson Aug 24 '19 at 10:21
here is reference, you can test. https://stackoverflow.com/questions/9233912/connecting-sqlalchemy-to-msaccess – Yong Wang Aug 24 '19 at 10:34
It returns ['SQL Server'] - Gord Thompson – Bryan Banuelos Aug 24 '19 at 20:01
So the Access ODBC driver is not available to your Python app. However, if the list shows *just* 'SQL Server' then it suggests that you are running 64-bit Python because the list would be much longer if you were running 32-bit Python. Are you sure that you are running 64-bit Office? – Gord Thompson Aug 24 '19 at 20:17
Yes, 'Microsoft Access for Office 365 MS (16.0.11901.20204) 64-bit' – Bryan Banuelos Aug 25 '19 at 04:47
You may need to manually install the 64-bit version of the ODBC driver. See [this article](https://learn.microsoft.com/en-us/office/troubleshoot/access/cannot-use-odbc-or-oledb) for details. – Gord Thompson Aug 25 '19 at 08:58

How to connect Python to Microsoft Access database file?

0 Answers0