VBA Unbound Recordset Object?

  • Thread starter Thread starter Tony_VBACoder
  • Start date Start date
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
 
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
 
Back
Top