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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sending array to table 1
Loading query values into an array 1
Copy or addnew from an array 1
Append array to recordset 1
multidimensional array and data table help 3
Arrays from Access to Excel 3
Access Access Table Array 1
Array by getrows to listbox - date format problem 0

Back
Top