HiCustomer

Thank you for the question. In order to do this, you can use MS Access "export" function. The easiest way to do this would be to select your range (25,000 at a time), and click export. There will be an arrow next to the export button that allows you to export the selected range. You will have to do this 40 times in order to get all 1,000,000 records, however it will not take too long. You could also write a VBA script to loop through the range in the table 25,000 records at a time until the end of the table is reached, however it will take longer to write the script than it would to do this manually. The manual method would consist of the following:

Back up your database by saving the MDB file to another folder
Open table
Select first 25,000 rows
Click File -> Export
Choose XLS (Excel 97 - 2003) from the dropdown where it says "Save as Type"
Enter your file name
Click the checkbox that says "Save Formatted"
Click the small arrow next to "Export All", and click "Save Selection", which will save only the records you have selected.
Select next 25,000 rows in table, and repeat until you are finished.

Hope this helps!

Please accept my answer if you feel my assistance was helpful.

Thanks for the reply. Unfortunately, there is nothing like this built in to MS Access, mainly because it is a fairly low priority use-case. MS Access provides an interface to the Microsoft API's, so you could use MS Access API code (VBA) to perform this operation if you are so inclined. Just like MS Word or Excel, you can select a range of records from an MS Excel table. Using VBA programming appears to be the only way to do this. Hope this helps,