Dim R1 As New ADODB.Recordset Dim R2 As New ADODB.Recordset '假设test1表是源表,test2是目的表。数据库的连接代码你可以自己写一下,我省掉了 R1.Open "select * from test1" R2.Open "select * from test2" Do While R1.EOF R2.AddNew R2.Fields("姓名") = R1.Fields("姓名") R2.Fields("年龄") = R1.Fields("年龄") R1.MoveNext R2.Update Loop
Dim R2 As New ADODB.Recordset
'假设test1表是源表,test2是目的表。数据库的连接代码你可以自己写一下,我省掉了
R1.Open "select * from test1"
R2.Open "select * from test2"
Do While R1.EOF
R2.AddNew
R2.Fields("姓名") = R1.Fields("姓名")
R2.Fields("年龄") = R1.Fields("年龄")
R1.MoveNext
R2.Update
Loop