如何使用Python将XML数据直接导入SQL server？

import xml.etree.ElementTree as ET
import pyodbc

tree = ET.parse('data.xml')  # 替换为你的XML文件路径
root = tree.getroot()

conn = pyodbc.connect('DRIVER={SQL Server};SERVER=your_server;DATABASE=your_database;UID=your_username;PWD=your_password')
cursor = conn.cursor()

cursor.execute('CREATE TABLE IF NOT EXISTS your_table (column1 datatype1, column2 datatype2, ...)')

for child in root:
    values = []
    for subchild in child:
        values.append(subchild.text)
    query = "INSERT INTO your_table (column1, column2, ...) VALUES (?, ?, ...)"
    cursor.execute(query, values)
    conn.commit()

cursor.close()
conn.close()