Gau, This prints the names of the columns in my database.
# Modification of # http://aspn.activestate.com/ASPN/Cookbook/Python/Recipe/389535 # Instructions for customizing are at: # http://www.egenix.com/files/python/mxODBC.html import mx.ODBC.Windows as odbc driv='DRIVER={Microsoft Access Driver (*.mdb)};DBQ=d:/Access Databases/Quotations2005' conn = odbc.DriverConnect(driv) c = conn.cursor() # get the column names from Table1 c.execute ("SELECT * FROM Table1") # get column names cols= [ i[0] for i in c.description ] print '\n\ncols=',cols -- http://mail.python.org/mailman/listinfo/python-list
