Private Sub Command2_Click() Dim db As New ADODB.Connection Dim rs As New ADODB.Recordset Dim rs1 As New ADODB.Recordset Dim i As Long, ii As Longdb.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb" db.Open rs.CursorLocation = adUseClient rs.Open "select * from a", db i = rs.RecordCount If i > 1000 Then'如果超过1000条就处理 rs1.Open "b", db, adOpenDynamic, adLockOptimistic For ii = 1 To i rs.Move ii rs1.AddNew rs1!id = rs!id rs1!Name = rs!Name'替换成你的字段名 rs1.Update Next ii rs.Close rs1.Close db.Execute "delete from a"'清除a表 End If End Sub
Dim db As New ADODB.Connection
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim i As Long, ii As Longdb.ConnectionString = "provider=microsoft.jet.oledb.4.0;" & "data source=" & App.Path & "\dev.mdb"
db.Open
rs.CursorLocation = adUseClient
rs.Open "select * from a", db
i = rs.RecordCount
If i > 1000 Then'如果超过1000条就处理
rs1.Open "b", db, adOpenDynamic, adLockOptimistic
For ii = 1 To i
rs.Move ii
rs1.AddNew
rs1!id = rs!id
rs1!Name = rs!Name'替换成你的字段名
rs1.Update
Next ii
rs.Close
rs1.Close
db.Execute "delete from a"'清除a表
End If
End Sub
Recordset.open "select * from table",connectionv, adOpenDynamic, adLockOptimistic
msgbox Recordset.RecordCount
请问将数据插入到b表有没有更快的方法?
判断 select count(*) from a > 10000
INSERT INTO b SELECT a.* FROM a
delete from a