access的mdb转mysql

CREATE TABLE Users (
    ID INT PRIMARY KEY,
    Name VARCHAR(100),
    Email VARCHAR(100)
);

import pandas as pd
import pyodbc
import mysql.connector

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

# 读取数据
access_cursor.execute("SELECT * FROM Users")
data = access_cursor.fetchall()

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

# 插入数据到MySQL
for row in data:
    mysql_cursor.execute("INSERT INTO Users (ID, Name, Email) VALUES (%s, %s, %s)", row)

# 提交更改并关闭连接
mysql_conn.commit()
access_cursor.close()
access_conn.close()
mysql_cursor.close()
mysql_conn.close()