creating an access db (1 Viewer)

[FireStrike]

I currently have a recordset that I need to put into a local access database. This recordset is being pulled from a server. I am currently reading in this recordset one record at a time and pushing it into an array. I am then using an insert into statement to push this array into my access table. I was wondering if there is a faster way. This record set has 3400+ records and takes a very long time. I was thinking about pushing the entire thing into a multidemension dynamic array. the problem with this is that I can only think of one way to push this into my access db, and that is one row at a time, cause the same problem as I have now, just eating up much more memory. Can anyone think of a better, more efficient way of doing this?

 

[Banana]

Try and read up on append query or bulk updates.