我同意FrustratedWithFormsDesigner。＃2似乎是最简单的方法。
如果您决定走那条路线，这是一些经过测试的代码（需要pyodbc）：
import csvimport pyodbcMDB = 'c:/path/to/my.mdb'DRV = '{Microsoft Access Driver (*.mdb)}'PWD = 'mypassword'conn = pyodbc.connect('DRIVER=%s;DBQ=%s;PWD=%s' % (DRV,MDB,PWD))curs = conn.cursor()SQL = 'SELECt * FROM mytable;' # insert your query herecurs.execute(SQL)rows = curs.fetchall()curs.close()conn.close()# you could change the 'w' to 'a' for subsequent queriescsv_writer = csv.writer(open('mytable.csv', 'w'), lineterminator='n')for row in rows: csv_writer.writerow(row)
