Dim db As new ADODB.Connection Dim rs As new ADODB.Recordset Dim rs2 As new ADODB.Recordset db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\tyq.mdb;Persist Security Info=False;" rs.Open "select * from biao", db, adOpenKeyset, adLockOptimistic set rs2=rs rs2和rs就是lz要的数据集,比一条一条插入保存快多了
.Fields.Append "AAA", adBSTR, 255
.Fields.Append "BBB", adBSTR, 255
.Fields.Append "CCC", adBSTR, 255
.Fields.Append "DDD", adBSTR, 255
.Fields.Append "EEE", adBSTR, 255
.Fields.Append "FFF", adBSTR, 255
.CursorType = adOpenStatic
.LockType = adLockOptimistic
.Open
End With
For i = 0 To j‘记录集数
rsInput.AddNew
For j = 0 To rec.Fields.Count-1
rsInput.Fields(j) = rec.Fields(j)
Next j
rsInput.Update
Next i
http://blog.csdn.net/chinaboyzyq/archive/2010/03/27/5422713.aspx
Dim rs As new ADODB.Recordset
Dim rs2 As new ADODB.Recordset
db.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\tyq.mdb;Persist Security Info=False;"
rs.Open "select * from biao", db, adOpenKeyset, adLockOptimistic
set rs2=rs
rs2和rs就是lz要的数据集,比一条一条插入保存快多了
我也只能一条条插入 不是说记录都是从这个数据库里查的~