Export to different Excel Workbooks

[mac_see]

I have a table with 327675 records, I want to export these records to different workbooks.

Workbook1 should contain the first 65535 records and so on till Workbook5.

I want separate workbooks and not separate worksheets in the same workbook.
Is this possible?



Maxi

 

[timwangTM]

Seems no direct way in Access to achieve this. However, why not setup 5 queries in Access for your table, one query store max. 65534 records.
Setup such 5 queries ae very easy if your table have one AutoNumber field. No need any coding, just take the advantage of Access built-in functionalities.
Always try to make simple solution, that's my principle.