VBA Unbound Recordset Object?

[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

 

[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

 

[Tony_VBACoder]

Thank you...that was exactly what I was looking for.

FYI...here is great post for an example of a disconnected
ADO Recordset:

http://www.tek-tips.com/viewthread.cfm?qid=904145