Python使用QSqlDatabase将数据从Qtable Widget插入Ms Access

from PyQt5.QtSql import QSqlDatabase, QSqlQuery
from PyQt5.QtWidgets import QApplication, QTableWidget, QTableWidgetItem

db = QSqlDatabase.addDatabase('QODBC')
db.setDatabaseName('DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path/to/your/database.accdb')
if not db.open():
    print('无法连接到数据库')
    exit(1)

query = QSqlQuery()
query.prepare('INSERT INTO TableName (Column1, Column2) VALUES (?, ?)')

table = QTableWidget()  # 假设已经创建了QTableWidget并填充了数据
for row in range(table.rowCount()):
    column1 = table.item(row, 0).text()
    column2 = table.item(row, 1).text()
    query.addBindValue(column1)
    query.addBindValue(column2)
    query.exec()

db.close()