Choose First 65,000 records of a recordset

J

JanetF

Hello,

I have a query that has over 200,000 records and I need to export all the
records to a text file. Problem is I can only export 65,000 records at a
time. How do I tell the query to run the first 65,000 records , then get it
to run the next 65,000, etc.? Thanks in advance.

Janet
 
K

Ken Snell [MVP]

Using TransferText, there is not a limit to the number of records you can
export. There is a limit of 65,536 records using TransferSpreadsheet.
 
Top