I need to export an array of values generated from VBA/Excel to an Access database, and also append the Access database table periodically as the VBA code runs and updates the array.

I have to use Access due to row limitations in Excel.

Any thoughts on how to get started on this would be useful.