Python如何将MS Excel数据导入MS Access数据库

2024-03-28 18:56:24 发布

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

我正在尝试使用以下代码执行此操作,但如果正确与否,我不执行此操作

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


Tags: driverconnectconnusersdocumentsmicrosoftdbfilepyodbc