Exporting to Excel w/ large # of records

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

Guest

I need to export a large # of records to an Excel workbook. The number of records is over the 65K that Excel accepts. How can I select chunks of the table to export into same Excel file, but different worksheets. I have code to do this for txt files, but not Excel...I think I need to use TransferSpreadSheet function, but am not sure how to limit the records.

thk
 
If your problem is limiting he records. Have you thought
about exporting a query that limits the records to each
work book?

Dean
-----Original Message-----
I need to export a large # of records to an Excel
Click to expand...
workbook. The number of records is over the 65K that
Excel accepts. How can I select chunks of the table to
export into same Excel file, but different worksheets. I
have code to do this for txt files, but not Excel...I
think I need to use TransferSpreadSheet function, but am
not sure how to limit the records.
 
Back
Top