Python pyodbc connect to ms access database

Question

I am trying to connect my access database so I can dump my data into the table in the database. This the code I use:

import pyodbc
access_database_file = "C:\\Users\\Moyp\\DataPointe.accdb"
ODBC_CONN_STR = 'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=%s;' %access_database_file
conn = pyodbc.connect(ODBC_CONN_STR)

However, I keep receiving this error:

Traceback (most recent call last):
  File "C:\Anaconda\lib\site-packages\IPython\core\interactiveshell.py", line 3035, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-6-a4daec7c49a9>", line 1, in <module>
    conn = pyodbc.connect(ODBC_CONN_STR)
Error: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')

collarblind · Accepted Answer · 2015-07-09 15:18:27Z

6

I fixed the issue. I was using 64 bit Python and 32 bit MS Access. After I downgraded my 64 bit Python to 32 it worked fine.

answered Jul 9, 2015 at 15:18

collarblind

4,74913 gold badges33 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

MSIS Over a year ago

@ I am not George: Where do you find the settings?

Collectives™ on Stack Overflow

Python pyodbc connect to ms access database

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related