这样:
把这句:
'如下语句有BUG
IEs.Execute "insert into ieod01d14 select * from tempRecordset" 换成:
dim strsql as string
dim i as integer
do until temprecordset.eof
strsql = strsql & "'" & re(i) & "'," '这里具体要看数据类型。字符要夹两个单括号数字的不用
i=i+1
loop
i = len(strsql)
strsql = mid(strsql,1,i-1)
IEs.Execute "insert into ieod01d14 values (" & strsql & ")"
把这句:
'如下语句有BUG
IEs.Execute "insert into ieod01d14 select * from tempRecordset" 换成:
dim strsql as string
dim i as integer
do until temprecordset.eof
strsql = strsql & "'" & re(i) & "'," '这里具体要看数据类型。字符要夹两个单括号数字的不用
i=i+1
loop
i = len(strsql)
strsql = mid(strsql,1,i-1)
IEs.Execute "insert into ieod01d14 values (" & strsql & ")"
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货