(Note: Newer engines can usually read files created by older engines, but older engines cannot read newer file formats like .accdb ) .
using System.Data.OleDb;
The (often referred to as the "ACE Engine") is a set of driver technologies provided by Microsoft. Its primary purpose is to provide a bridge between software applications and data stored in Microsoft Office files (Access, Excel) and SQL-based desktop databases. microsoft access database engine
conn_str = ( r"Driver=Microsoft Access Driver (*.mdb, *.accdb);" r"DBQ=C:\Data\Inventory.accdb;" ) conn = pyodbc.connect(conn_str) cursor = conn.cursor() cursor.execute("SELECT ProductName, Quantity FROM Products WHERE Quantity < 10") for row in cursor.fetchall(): print(row.ProductName, row.Quantity) conn.close() (Note: Newer engines can usually read files created