Add records to table in bulk (not one record at a time) via multidimensional array

[mountainclimber]

I don't understand the data structure well enough - 1305 fields involved in this calc - WOW! A table for each field/factor????

I've never had to deal with this volume of data. I expect you will quickly outgrow Access.

Well, I am not storing all of that data in Access. For now I am just getting all of the aggregate data for one day and storing it, which is about 30k records a day. We hope to do it historically at some point, but for now we are just doing it on going-forward basis. We have all the data in Excel sheets for a few years now so we can always go get it later. Anyway, once we have maxed out Access we will use postgreSQL as a backend and Access as our front end:
http://www.postgresonline.com/journa...ostgreSQL.html

Well, the 15 calcs we want to do will be on all of the 1305 fields/factors. Meaning it will be a lot of repetition, so speed is key.

[June7]

Still don't understand data structure. Can't recall a situation that required calcs anywhere near 1305 fields.