exporting more than 65000 rows

The result of an Access query yields over 200,000 records. I need to export into Excel, but Access can only export 65,000 records. If I need to break the results into multiple 65,000 record instances, how do I do that? Or is there another way to get around this limitation?

Can you apply more filter criteria to further group the records?

Otherwise, code could write data to Excel one field at a time from a recordset in a loop with a counter variable and repeats the loop for every 65,000 records to a new worksheet.

Thanks for the reply. I actually found my answer on another similar thread. The problem was caused by checking the "Export Data with Formatting and Layout" box. Once I unchecked that, everything exported fine. Nice to have a simple solution.

Thanks, I had the same problem today. Quickly solved.