如何向ACCESS中添加多个记录 如何向ACCESS中添加多个记录? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 for i=0 to 100 insert into yourtable values('a','b',..)next i For n = 1 To 100 For m = 1 To 156 For k = 1 To 186 ' array(n, m, k)是个已知数组,把它添加到ACCESS的表state中,如何添加 Next k Next m Next n For n = 1 To 100 For m = 1 To 156 For k = 1 To 186 strS = "insert into mytable ( " & _ " id " & _ " ,state " & _ " ) " & _ " values( " & _ " '" & strid & "' " & _ " ,'" & Array(n, m, k) & "' " & _ " )" Next k Next m Next n For n = 1 To 100 For m = 1 To 156 For k = 1 To 186 rs.AddNew rs.Fields(0) = strid rs.Fields(1) = Array(n, m, k) rs.Update Next k Next m Next n con.BeginTrans For n = 1 To 100 For m = 1 To 156 For k = 1 To 186 strS = "insert into mytable ( " & _ " id " & _ " ,state " & _ " ) " & _ " values( " & _ " '" & strid & "' " & _ " ,'" & Array(n, m, k) & "' " & _ " )" con.Execute strs Next k Next m Next n con.CommitTrans 一条一条添加速度太慢了,如果小于50条记录,可以使用Union,如果大于50条,则分几次,每次用Union添加50条记录,这样速度快一点 [新手提问]菜单打勾.checked遇到的问题 webbrowser问题 万分急啦,大哥哥,如果帮得到我,我给100分,只是一个小小的问题 怎么制作程序的补丁升级文件 各路英雄,请帮忙了,EXCEL和CELL的问题 只修改了dll,exe要重新编译吗? 求一份 工资管理系统 源码参考一下! 依靠vbio.dll,如何读取ISA插槽上插卡的数据? 如何使VB在数据库中查询得出的汉字按其拼音的字母顺序排序? 能不能在MSHFlexGrid显示的记录上选中几条记录,然后将其删除? 一个简单问题! 关于表达式的合法性检查? 在线等
for i=0 to 100
insert into yourtable values('a','b',..)
next i
For m = 1 To 156
For k = 1 To 186 ' array(n, m, k)是个已知数组,把它添加到ACCESS的表state中,如何添加 Next k Next m
Next n
For m = 1 To 156
For k = 1 To 186
strS = "insert into mytable ( " & _
" id " & _
" ,state " & _
" ) " & _
" values( " & _
" '" & strid & "' " & _
" ,'" & Array(n, m, k) & "' " & _
" )"
Next k
Next m
Next n
For m = 1 To 156
For k = 1 To 186
rs.AddNew
rs.Fields(0) = strid
rs.Fields(1) = Array(n, m, k)
rs.Update Next k
Next m
Next n
con.BeginTrans For n = 1 To 100
For m = 1 To 156
For k = 1 To 186
strS = "insert into mytable ( " & _
" id " & _
" ,state " & _
" ) " & _
" values( " & _
" '" & strid & "' " & _
" ,'" & Array(n, m, k) & "' " & _
" )"
con.Execute strs
Next k
Next m
Next n
con.CommitTrans
如果大于50条,则分几次,每次用Union添加50条记录,这样速度快一点