如何从在线CSV插入SQL Server数据库数据？

import csv
import pyodbc

# 解析CSV文件
def parse_csv(csv_url):
    data = []
    response = requests.get(csv_url)
    lines = response.text.split("\n")
    reader = csv.reader(lines)
    for row in reader:
        data.append(row)
    return data

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

# 创建表结构
def create_table(cursor):
    cursor.execute('CREATE TABLE YourTable (column1 datatype1, column2 datatype2, ...)')
    cursor.commit()

# 插入数据
def insert_data(cursor, data):
    for row in data:
        cursor.execute('INSERT INTO YourTable (column1, column2, ...) VALUES (?, ?, ...)', row)
    cursor.commit()

# 关闭数据库连接
def close_connection(conn, cursor):
    cursor.close()
    conn.close()

# 主函数
def main():
    csv_url = "http://example.com/your_csv_file.csv"
    data = parse_csv(csv_url)
    conn, cursor = connect_to_database()
    create_table(cursor)
    insert_data(cursor, data)
    close_connection(conn, cursor)

if __name__ == "__main__":
    main()