基本的Pyodbc批量插入

解决此问题的最佳方法是使用pyodbc函数

executemany

ds1Cursor.execute(selectSql)result = ds1Cursor.fetchall()ds2Cursor.executemany('INSERT INTO [TableName] (Col1, Col2, Col3) VALUES (?, ?, ?)', result)ds2Cursor.commit()