使用DataReader和OLEDB Jet数据提供程序读取CSV文件时,如何控制列数据类型？

import oledb
import pyodbc

# 建立与数据源的连接
conn_string = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source<datasource>;Extended Properties='text;HDR=Yes;FMT=CSVDelimited'"
con = oledb.connect(conn_string)

# 准备读取CSV文件的数据
data = 'c:\data\mydata.csv'
crsr = oledb.cursor()

# 从CSV文件中读取数据
cur_db_table = oledb.cursor().cursor_get_recordset(table_name = "tb_mydata", key_field_name = ['ID', 'name'], field_names = None, field_types = None)

# 打开CSV文件并添加数据源名称和格式选项
csv_read = oledb.read_csv(data, key_field_name='ID', field_names=['ID', 'name'], header=True, delim=',', format='CSVDelimited')

# 设置数据源的列数据类型以匹配CSV文件中的格式
for row in csv_read:
    sqlcmd = 'ALTER TABLE #table_nameALTER COLUMN ID VARCHAR(50) NULL NULL ON UPDATE CASCADE'
    crsr.execute(sqlcmd)
    sqlcmd = 'ALTER TABLE #table_nameALTER COLUMN name VARCHAR(50) NOT NULL'
    crsr.execute(sqlcmd)
    crsr.commit()

# 将数据添加到原始数据表
sqlcmd = "INSERT INTO tb_mydata('ID', 'name') SELECT ID AS ID, name AS name FROM """ + data +""""
crsr.execute(sqlcmd)

# 添加格式列
formatted_data = oledb.read_csv(data, key_field_name='ID', field_names=['ID', 'name'], header=False, delim=',', format='%(name)s VARCHAR(50)')
formatted_table = oledb.cursor().cursor_get_recordset(table_name = "tb_formatted_names", key_field_name = ['ID', 'name'], field_names = None, field_types = None)
for row in formatted_data:
    oledb.cursor().recordset_add_to_table(formatted_table, [(row[0], row[1])])