我正在尝试使用以下代码执行此操作,但如果正确与否,我不执行此操作
import pyodbc
DBFile = r'C:\Users\sidhant\Documents\Database1.accdb'
conn = pyodbc.connect('DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ='+DBFile)
exfile = r'C:\Users\sidhant\Documents\Sheet1.xlsx'
conn1 = pyodbc.connect('DRIVER={Microsoft Excel Driver \
(*.xlsx)};DBQ='+exfile,autocommit=True)
curs1 = conn1.cursor()
excel_results = curs1.execute('select [a_column] from [sheet1$]').fetchall()
curs1.executemany('insert into mytable (mycolumn) values (?)', excel_results)
conn.commit
它给了我这个错误
C:\Users\sidhant\PycharmProjects\untitled\venv\Scripts\python.exe C:/Users/sidhant/PycharmProjects/untitled/practice.py Traceback (most recent call last): File "C:/Users/sidhant/PycharmProjects/untitled/practice.py", line 5, in conn = pyodbc.connect('DRIVER={access (*.mdb, *.accdb)};DBQ='+DBFile) pyodbc.InterfaceError: ('IM002', '[IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (0) (SQLDriverConnect)')
Process finished with exit code 1
下载并安装this。应该会处理好的。在
不确定是否重要,但这正是我使用的字符串
相关问题 更多 >
编程相关推荐