Answers for "python odbc access database"

0

python odbc access database

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)
Posted by: Guest on June-24-2020

Code answers related to "python odbc access database"

Python Answers by Framework

Browse Popular Code Answers by Language