使用特定字段将csv文件数据存储到MS Access数据库

import csv
import pyodbc

# 读取CSV文件数据
csv_file = 'data.csv'
data = []
with open(csv_file, 'r') as file:
    reader = csv.reader(file)
    for row in reader:
        data.append(row)

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

# 创建游标对象
cursor = conn.cursor()

# 创建表格
table_name = 'csv_data'
create_table_sql = f"CREATE TABLE {table_name} (column1 TEXT, column2 TEXT, column3 TEXT)"
cursor.execute(create_table_sql)

# 插入数据
insert_sql = f"INSERT INTO {table_name} (column1, column2, column3) VALUES (?, ?, ?)"
for row in data:
    cursor.execute(insert_sql, row)

# 提交事务
conn.commit()

# 关闭游标和数据库连接
cursor.close()
conn.close()