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.
Thanks.
I have to use Access due to row limitations in Excel.
Any thoughts on how to get started on this would be useful.
Thanks.