I have an Access table with an amount of records that changes every time another macro is run. I need to export this data into Excel files, but the catch is that each file must only have 2,000 records in it. So if I have say 10,000 in total that would 5 Excel files with 2,000 records per file.
I'm trying to do something via the Access DAO object model and loop through the records, but I basically have 0 experience exporting data this way so any help would be greatly appreciated.
Thank you!
EDIT: I found this old thread which I think solves my problem. Split MS Access table into parts and export into Excel using VBA