批量插入SQL数据时，占位符数量与参数数量不匹配如何解决？

import pyodbc

# 连接数据库
conn = pyodbc.connect(r'driver={microsoft access driver (*.mdb, *.accdb)};dbq=d:\东和.accdb')

# 创建连接池对象
connpool = mysqlconnectionpool()

# 创建游标
cursor = conn.cursor()

# 查询数据
cursor.execute('select * from 配方列表')

list1 = []
# 逐行读取数据
for row in cursor.fetchall():
    list1.append(row)

# 更新 sql 语句以匹配元组数量
sql = "insert into plan_peifang_list (dingdanhao, kehu, zhilianghao, zhongliang, time, waibuzhilianghao) values (?, ?, ?, ?, ?, ?)"

# 批量插入数据
connpool.insert_all(sql, list1)

import pyodbc

# 连接数据库
conn = pyodbc.connect(r'Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBQ=D:\东和.accdb')

# 创建连接池对象
ConnPool = MySQLConnectionPool()

# 创建游标
cursor = conn.cursor()

# 查询数据
cursor.execute('SELECT * FROM 配方列表')

# 逐行读取数据
for row in cursor.fetchall():
    sql = "INSERT INTO plan_peifang_list (dingdanhao, kehu, zhilianghao, zhongliang, time, waibuzhilianghao) VALUES (?, ?, ?, ?, ?, ?)"
    ConnPool.insert(sql, row)