循环建议用 do while not rs.eof ...... loop recordcount为近似值,不可靠(做过实验的)我喜欢用listview控件
事物用 连接.begintrans 连接.committrans .....
从msflexgrid保存到Table:with msflexgrid1 for i=1 to .rows-1 strSQL="insert into table (f1,f2) values ('" & .textmatrix(i,1) & "','" & .textmatrix(i,2) & "'" objConn.execute strSQL next i end with
do while not rs.eof
......
loop
recordcount为近似值,不可靠(做过实验的)我喜欢用listview控件
连接.committrans
.....
for i=1 to .rows-1
strSQL="insert into table (f1,f2) values ('" & .textmatrix(i,1) & "','" & .textmatrix(i,2) & "'"
objConn.execute strSQL
next i
end with
试过了,access,6000条记录,会造成死机,1000条好点,但速度极慢