Access
download Microsoft ODBC Driver 13 for SQL Server, 64 bit:
install ODBC Driver:
Open cmd.exe as administrator, type pip install pyodbc:
put access database somewhere easy to find:
change location string in python code to point to your database:
import pyodbc
driver = "Driver={Microsoft Access Driver (*.mdb, *.accdb)};"
location = "DBQ=C:\\access\\shop.accdb"
connection = pyodbc.connect(driver + location)
cursor = connection.cursor() #for traversal of records
resultSet = cursor.execute("SELECT * FROM customers")
for row in resultSet:
print(row.firstName)
cursor.close()
connection.close()
run in IDLE or favourite IDE: