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:
