Populating an ADODB.Recordset without DB 1

[RicoCali]

I have a situation where I have to populate a recordset without getting a physical database involve. How would I go about doing this?

 

[zemp]

Use the .Fields.Append method to add the fields that you need. Then the .addnew method to add a record and set the field values, don't forget to update the recordset.

   Set rs = New ADODB.Recordset
   With rs
      .Fields.Append "Name", adVarChar, 120
      .Fields.Append "Address", adVarChar, 120
      ....
   End With

   With rs
      .AddNew
      .Fields(0).value = <Name>
      .Fields(1).value = <Address>
      ...
      .Update
  End with

zemp

 

[RicoCali]

Thank you! Can I buy you a beer?

 

[zemp]

One thing I forgot, asfter you have appended all your fields don't forget to open the recordset with the .Open command.

zemp