将数据从Excel上载到SQL格式化日期

import pandas as pd
import pyodbc

# 读取Excel文件
excel_file = 'path_to_your_excel_file.xlsx'
df = pd.read_excel(excel_file)

# 假设Excel中的日期列名为'DateColumn'
df['DateColumn'] = pd.to_datetime(df['DateColumn']).dt.strftime('%Y-%m-%d')

# 连接到SQL数据库
conn = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
cursor = conn.cursor()

# 将数据插入SQL数据库
for index, row in df.iterrows():
    cursor.execute("INSERT INTO your_table (DateColumn, OtherColumns) VALUES (?, ?)", row['DateColumn'], row['OtherColumns'])

conn.commit()
cursor.close()
conn.close()

df['DateColumn'] = pd.to_datetime(df['DateColumn'], errors='coerce')