Array to Table

[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.

 

[Nick Coe \(UK\)]

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.