bulk insert into ms access database

[James_R]

I am trying to insert a 2d array of data into a MS Access database and the only way i can get it to work is by inserting 1 record at a time which takes a long time to execute

is there a way to make a recordset from a 2d array of doubles?

[jcarmody]

I'd build a SQL query with INSERT statements and execute that.  It'll require you to loop through your array to build the query, but you'll only touch the database once.