Exporting more than 66000 records to excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to export a file that contains over 100,000 records to excel. It
stops at the 65... limit. How can i fore it to go to second sheet in excel
 
You need to export a query that contains the first part of the data (e.g. A
to K) to one sheet. Then modify the query (or use a second query) to return
the remainder of the records (e.g. L to Z) and export that to another sheet.

Contrary to what Help says, you can use the Range argument in
TransferSpreadsheet to specify the name of the worksheet.
 
Back
Top