我已經(jīng)為此工作好幾天了。請有人提供任何您可以提供的建議。這是我當(dāng)前的代碼（它不起作用，我知道為什么它不起作用）：import pyodbcimport openpyxlpath = ('C:\\Access_Test.xlsx')wb = openpyxl.load_workbook(path)sheet = wb.activeb2 = a2 = sheet['A2']b2 = sheet['B2']c2 = sheet['C2']d2 = sheet['D2']e2 = sheet['E2']f2 = sheet['F2']g2 = sheet['G2']h2 = sheet['H2']i2 = sheet['I2']j2 = sheet['J2']k2 = sheet['K2']l2 = sheet['L2']m2 = sheet['M2']n2 = sheet['N2']o2 = sheet['O2']test2 = (")'")test =  (a2.value, b2.value, c2.value, d2.value, e2.value, f2.value, g2.value, h2.value, i2.value, j2.value, k2.value, l2.value, m2.value),(test2)  #Everything to this point is fine.  I can read & print everything from the Excel document (though the formatting is an issue with how the query statements work in pyodbc).driver = '{Microsoft Access Driver(*.mdb, *accdb)}'filepath = 'C:\\Users\\Db_Mngr\\Desktop\\PythonTests\\Microsoft Studio Projects\\HUD Report-2001-Copy For Python.mdb'#Find data sourcesmyDataSources = pyodbc.dataSources()access_driver = myDataSources['MS Access Database']#This is the full command to open the Access databasecnxn = pyodbc.connect(driver=access_driver, dbq=filepath, autocommit=True)crsr = cnxn.cursor()crsr.execute(str(test))如果我使用：print:(test)我的輸出如下所示（此測試的所有數(shù)據(jù)都是假的）：("'''INSERT INTO Python_Test([Case2], [Last], [First], [Initial Intake], [Intake], [Age], [Gender], [Ethnic], [Race], [DOB], [SSN], [Educ Lvl], [Marital])VALUES", ('Sep00000', 'Test', 'Test', '01/01/2020', '01/01/2020', 1, 'Male', 'A. Hispanic', 'E. White', '01/01/2020', 0, 'High School'), ")'")正如你所看到的，對于 pyodbc 來說，這大約是 70% 正確的，但它顯然會拋出錯誤（開頭太多引號，“VALUES”后面的引號，“VALUES”后面的“”......等等，你明白我的意思）。有誰能夠嘗試解釋如何使這段代碼發(fā)揮作用嗎？刪除開頭的額外引號不一定是最大的問題，我想我可以解決這個問題；但“VALUES”部分之后發(fā)生的一切都是一團(tuán)糟。如有任何反饋，將不勝感激！