“how to open mdb file in python” Code Answer

1. import pyodbc.
2. ​
3. conn = pyodbc. connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path where you stored the Access file\file name.accdb;')
4. cursor = conn. cursor()
5. cursor. execute('select * from table name')
6. for row in cursor. fetchall():
7. print (row)

My Insite