I know I can not be the first to be doing this !
I am simply combining recordsets of the same type from multiple MDBs.

I have a 'virtual' recordset

Dim myRst as new adodb.recordset

I use the Fields,append collection method to generate the field names.

Open the myRST, then start setting values from my source recordset by iterating through each record and poking each individual field value into myRST.


I get the next mdb, generate the recordset and continue adding to myRST using the same methods.

Now...this take bloody ages.

Anyway to update the myRST with at least one record at a time in one hit rather the cycling through each records fields.

I have seen myRST.Update (Fields,Values) where you can pass an array of field names and an array of field values in one hit to store a record. What is then a convenient way of generating these arrays from my source recordset.


Appreciate any help or suggestions (..what..pack up and go home ?)

I am sure this is a common scenario..I have solution but it is very slow...

So how can I achieve this more efficiently ??

Thanks