access数据同步mysql

import pyodbc
import mysql.connector

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

# 连接MySQL数据库
mysql_conn = mysql.connector.connect(user='your_mysql_user', password='your_mysql_password', host='your_mysql_host', database='your_mysql_db')
mysql_cursor = mysql_conn.cursor()

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

# 将数据插入到MySQL数据库中
for row in rows:
    mysql_cursor.execute("INSERT INTO your_mysql_table (column1, column2, column3) VALUES (%s, %s, %s)", row)

# 提交事务
mysql_conn.commit()

# 关闭连接
access_cursor.close()
access_conn.close()
mysql_cursor.close()
mysql_conn.close()