哪个模块支持读写mdb格式的数据库文件

Eyrever

请问python中哪个模块可以支持读写mdb格式的数据库文件，如果有前辈可以给出示范代码更是感谢不尽

crossin先生

pyodbc

1. import csv, pyodbc
   
2. 
   
3. # set up some constants
   
4. MDB = 'c:/path/to/my.mdb'; DRV = '{Microsoft Access Driver (*.mdb)}'; PWD = 'pw'
   
5. 
   
6. # connect to db
   
7. con = pyodbc.connect('DRIVER={};DBQ={};PWD={}'.format(DRV,MDB,PWD))
   
8. cur = con.cursor()
   
9. 
   
10. # run a query and get the results
    
11. SQL = 'SELECT * FROM mytable;' # your query goes here
    
12. rows = cur.execute(SQL).fetchall()
    
13. cur.close()
    
14. con.close()
    
15. 
    
16. # you could change the mode from 'w' to 'a' (append) for any subsequent queries
    
17. with open('mytable.csv', 'wb') as fou:
    
18.     csv_writer = csv.writer(fou) # default field-delimiter is ","
    
19.     csv_writer.writerows(rows)

复制代码

没用过，网上搜的

Eyrever

没有人回答，是问得太傻了吗@crossin先生