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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Access table to Excel that has more than 65000 records 5
the best way to export 600K records 2
How to Export Gmail Emails to PST Format? 4
Export Record Limitations 1
Export Data from Data Access Page to Excel 1
export from access to excel 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Exporting to Excel 2007 1

Back
Top