VBA Unbound Recordset Object?

T

Tony_VBACoder

Is it possible to create an "Unbound" Recordset object
based on a non-existing table/query? If possible, I would
like to be able to loop through a Single Dimension Array
and populate my "Unbound" recordset object with code such
as:


For iCtr = 1 To UBount(MyArray())
rst.AddNew
!DummyField = MyArray(iCtr)
rst.Update
Next
 
A

Alex Dybenko

yes, you can, this is called disconnected ADO recordset, you can create a
new reocrdset, add fields what you need and then fill it with data.
HTH
 
Top