mdb 数据导出到mysql

import pyodbc
import mysql.connector
import csv

# 连接Access数据库
access_conn = pyodbc.connect(r'DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=path_to_your_mdb_file.mdb;')
access_cursor = access_conn.cursor()

# 连接MySQL数据库
mysql_conn = mysql.connector.connect(user='your_username', password='your_password', host='your_host', database='your_database')
mysql_cursor = mysql_conn.cursor()

# 查询Access数据库中的数据
access_cursor.execute("SELECT * FROM your_table")
rows = access_cursor.fetchall()

# 将数据写入CSV文件
with open('output.csv', 'w', newline='', encoding='utf-8') as csvfile:
    csv_writer = csv.writer(csvfile)
    csv_writer.writerow([i[0] for i in access_cursor.description])  # 写入表头
    csv_writer.writerows(rows)

# 将CSV文件导入MySQL数据库
with open('output.csv', 'r', encoding='utf-8') as csvfile:
    csv_reader = csv.reader(csvfile)
    next(csv_reader)  # 跳过表头
    for row in csv_reader:
        mysql_cursor.execute("INSERT INTO your_table (column1, column2, column3) VALUES (%s, %s, %s)", row)

# 提交事务并关闭连接
mysql_conn.commit()
access_conn.close()
mysql_conn.close()