如何循环执行多条SQL语句?SQL1~SQL10for i 1 to 10RS.open sql & i,Conn,1,3Rs.Closenext这样明显不行
如何循环执行多条SQL语句?
SQL1~SQL10
for i = 1 to 10
RS.open "sql" & i,Conn,1,3
Rs.Close
next
这样明显不行...求解决方案..
[解决办法]
for i = 1 to 10
ExecuteGlobal "RS.open sql" & i & ",Conn,1,3"
Rs.Close
next