如何将Python连接到microsoftaccess数据库文件?

2024-04-26 23:31:33 发布

您现在位置:Python中文网/ 问答频道 /正文

我正在尝试将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)

Tags: andpath数据库accessdriverconnectconncursor