Question : python odbc access database
Answered by : magnificent-mole-0l4b2ruizm3a
import pyodbc
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path where you stored the Access file\file name.accdb;')
cursor = conn.cursor()
cursor.execute('select * from table name')
for row in cursor.fetchall(): print (row)Source : https://datatofish.com/how-to-connect-python-to-ms-access-database-using-pyodbc/ | Last Update : Wed, 01 Jul 20