使用Python将CSV导入SQL Express

import pandas as pd
import pyodbc

data = pd.read_csv('data.csv')

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=database_name;UID=username;PWD=password')

cursor = conn.cursor()
cursor.execute('CREATE TABLE table_name (column1 datatype, column2 datatype, ...)')

data.to_sql('table_name', conn, if_exists='append', index=False)

import pandas as pd
import pyodbc

# 读取CSV文件
data = pd.read_csv('data.csv')

# 连接到SQL Express数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=server_name;DATABASE=database_name;UID=username;PWD=password')

# 创建数据库表
cursor = conn.cursor()
cursor.execute('CREATE TABLE table_name (column1 datatype, column2 datatype, ...)')

# 将数据插入数据库表
data.to_sql('table_name', conn, if_exists='append', index=False)

# 关闭数据库连接
conn.close()