dim conn as adodb.connection dim rs as adodb.recordset dim idnum as integersql="select * from table1 where 条件" rs.open sql,conn,3,2 if rs.eof =false then sql = "insert into table2 (字段1,2,3...)value(rs("字段1"),rs("字段2"),...)" conn.execute sql,idnum 'idnum用来返回新增记录数 end if
1、读出符合条件的数据,得到结果为记录集rst; 2、把rst的活动连接断开 set rst.ActiveConnection=nothing; 3、修改rst内容; 4、更新到数据库rst.UpdateBatch。
sql="insert into table2 (字段1,2,3...) values (rs("字段1"),rs("字段2"),...)"
dim sql as string sql="select * from 表 where 条件" dim con as adodb.connection dim rs as adodb.recordset dim cmd as adodb.commmand set con=new adodb.connection set rs=new adodb.recordset set cmd=new adodb.command com.connectionstring="" com.open rs.open sql,com,3,3 if rs.eof=false then set com.actionconnection=com com.excute "insert into table2 (字段1,2,3...) values (rs("字段1"),rs("字段2"),...);" end if close com
rs.open "select * from table1 where 条件",conn, adOpenStatic, adLockOptimistic
dim rs as adodb.recordset
dim idnum as integersql="select * from table1 where 条件"
rs.open sql,conn,3,2
if rs.eof =false then
sql = "insert into table2 (字段1,2,3...)value(rs("字段1"),rs("字段2"),...)"
conn.execute sql,idnum 'idnum用来返回新增记录数
end if
2、把rst的活动连接断开 set rst.ActiveConnection=nothing;
3、修改rst内容;
4、更新到数据库rst.UpdateBatch。
小弟刚入门,一定给分。
xing0091():
sql = "insert into table2 (字段1,2,3...)value(rs("字段1"),rs("字段2"),...)"
这句提示
缺少:语句结束。
应该是 sql= "insert into table2 (字段1,2,3...)values('"& rs("字段1") &"','"& rs("字段2") &"',...)"
我少写了个 s
values 后面的数值 如果是字符串的格式为 '"& 变量 &"' 数值型为 "& 变量 &"
sql="select * from 表 where 条件"
dim con as adodb.connection
dim rs as adodb.recordset
dim cmd as adodb.commmand
set con=new adodb.connection
set rs=new adodb.recordset
set cmd=new adodb.command
com.connectionstring=""
com.open
rs.open sql,com,3,3
if rs.eof=false then
set com.actionconnection=com
com.excute "insert into table2 (字段1,2,3...) values (rs("字段1"),rs("字段2"),...);"
end if
close com
rs.open "select * from table1 where 条件",conn, adOpenStatic, adLockOptimistic
conn.Execute "select * into table FROM rs "