我正在尝试将Python连接到Microsoft Access数据库文件,但不断出现以下错误:
64bit and Office 365 Business 64bit (Access).
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=[path];')
pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)
import pyodbc
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=[path];')
cursor = conn.cursor()
cursor.execute('select * from username_pw')
for row in cursor.fetchall():
print (row)
目前没有回答
相关问题 更多 >
编程相关推荐