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_username', password='your_password', host='your_host', database='your_database')
mysql_cursor = mysql_conn.cursor()

# 获取 ACCESS 数据库中的表名
access_cursor.execute("SELECT name FROM MSysObjects WHERE type=1 AND flags=0")
tables = access_cursor.fetchall()

# 导出每个表的结构和数据
for table in tables:
    table_name = table[0]
    
    # 导出表结构
    access_cursor.execute(f"SELECT * FROM {table_name} WHERE 1=0")
    columns = [column[0] for column in access_cursor.description]
    mysql_cursor.execute(f"CREATE TABLE {table_name} ({', '.join([f'{column} VARCHAR(255)' for column in columns])})")
    
    # 导出表数据
    access_cursor.execute(f"SELECT * FROM {table_name}")
    rows = access_cursor.fetchall()
    for row in rows:
        mysql_cursor.execute(f"INSERT INTO {table_name} VALUES ({', '.join(['%s']*len(row))})", row)
    
    # 提交更改
    mysql_conn.commit()

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