Array to Table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

You can use the GetRows() method to populate a two-dimensional array with the
contents of a recordset. What I need to do now is the same thing in the
opposite direction.

I know I can loop through the array and do Recordset.AddNew() for each record,
but I'm a little worried about the performance of such a routine, and was
wondering if anyone knows of a function similar to GetRows() (something like
ReceiveRows() for instance?) which'll do the job for me?

Pl tell me how this can be done.
 
Unfortunately not. At least, I've not found one and it
would have been useful once or twice... :-)

I think you're going to have to loop through the array
adding a new record to the recordset with each loop as you
say. You could try wrapping the whole thing up in a
transaction, I don't know if that would speed things up or
not. You'll have to experiment I think.
 
Back
Top