access直接转mysql

import pandas as pd
import pyodbc

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

# 查询数据并导出为 CSV
query = "SELECT * FROM your_table"
df = pd.read_sql(query, conn)
df.to_csv('output.csv', index=False)

cursor.close()
conn.close()

import mysql.connector
import csv

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

# 创建表
create_table_query = """
CREATE TABLE IF NOT EXISTS your_table (
    id INT AUTO_INCREMENT PRIMARY KEY,
    column1 VARCHAR(255),
    column2 INT,
    -- 添加其他列
)
"""
cursor.execute(create_table_query)

# 导入 CSV 数据
with open('output.csv', 'r') as csvfile:
    csvreader = csv.reader(csvfile)
    next(csvreader)  # 跳过表头
    for row in csvreader:
        insert_query = "INSERT INTO your_table (column1, column2) VALUES (%s, %s)"
        cursor.execute(insert_query, (row[0], row[1]))

mysql_conn.commit()
cursor.close()
mysql_conn.close()