I am unable to write to MS Access Database using pyodbc

Question

I am unable to write this df into the access table. What am I not doing right?

conn_str = (
    r'DRIVER={Microsoft Access Driver (*.mdb)};'
    r'DBQ=C:\Users\harsh\Desktop\Database1.mdb;'
)
cnxn = pyodbc.connect(conn_str)
SQL = 'SELECT * FROM Index_data;'
dfins = pd.read_sql(SQL, cnxn)
for index, row in dfins.iterrows():
    with cnxn.cursor() as crsr:
        crsr.execute('select * from df')
conn.commit()

MarianD · Accepted Answer · 2019-11-14 07:01:53Z

1

You probably have not installed ODBC driver for MS Access, or its name

"Microsoft Access Driver (*.mdb)"

don't agree with the string used in your program — for newer versions of Microsoft Access it is

"Microsoft Access Driver (*.mdb, *.accdb)".

So verify its name, or install it:

Open Control Panel, select Administrative Tools, then ODBC Data Sources.
New window will open up. Select “User DSN” tab.

Then verify the driver name, or install an appropriate Microsoft Access Driver — see for example Steps to create a New ODBC Connection on Windows 10.

edited Nov 14, 2019 at 7:01

answered Nov 14, 2019 at 6:36

MarianD

14.4k12 gold badges50 silver badges61 bronze badges

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

Collectives™ on Stack Overflow

I am unable to write to MS Access Database using pyodbc

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related