This example demonstrates how to read from a Microsoft Access database
via AdoDB and Python/Pywin32. This code opens a test database and
prints the names of the columns.
import win32com.client connection = win32com.client.Dispatch(r'ADODB.Connection') DSN = 'PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA SOURCE=c:\\pfad\\testdb.mdb;' connection.Open(DSN) recordset = win32com.client.Dispatch(r'ADODB.Recordset') recordset.Open('SELECT * FROM Auftraege', connection, 1, 3) fields_dict = {} for x in range(recordset.Fields.Count): fields_dict[x] = recordset.Fields.Item(x).Name print fields_dict[x], recordset.Fields.Item(x).Value