short snippet for querying an access database

query_mdb.py

# http://code.google.com/p/pyodbc/wiki/GettingStarted
# http://code.google.com/p/pyodbc/wiki/ConnectionStrings

import pyodbc

cnxn_string = r'DRIVER={Microsoft Access Driver (*.mdb)};DBQ=C:\PATH\TO\FILE.mdb'
cnxn = pyodbc.connect(cnxn_string)
cursor = cnxn.cursor()
cursor.execute("SELECT * from MY_TABLE")

rows = cursor.fetchall()
#row = cursor.fetchone()
for row in rows:
    print row

cursor.close()