Too many rows to Output

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

Guest

I issued the following command. The query extracts data from a table with
58,000 rows:
DoCmd.OutputTo acOutputQuery, "qryTT_tblTT_DataExt", acFormatXLS, “C:\
TT_Data.xls", False

I got the following error:

There are too many rows to output, based on the limitation specified by the
output format or by Performance Challange v 2.0 (Application Name).

Where would I change this parameter ?
 
Using DoCmd.OutputTo to export to Excel format has a limit of 16384
rows, and there's no way to change this.

If you use DoCmd.TransferSpreadsheet and specify Excel 8 or later (Excel
97 or later) format, the limit is 65536 rows.
 
Thank you.

John Nurick said:
Using DoCmd.OutputTo to export to Excel format has a limit of 16384
rows, and there's no way to change this.

If you use DoCmd.TransferSpreadsheet and specify Excel 8 or later (Excel
97 or later) format, the limit is 65536 rows.
Click to expand...
 
Can you please explain how I go about using DoCmd.TransferSpreadsheet (rather
than DoCmd.OutputTo). i.e. Where / How I specify this..?
thanks
 
Hi Dave,

If you're using File|Export, specify the most recent Access format (e.g.
"Microsoft Excel 97-2003" and do NOT click the Save Formatted box).

Otherwise, you can use TransferSpreadsheet in a macro, or
DoCmd.TransferSpreadsheet in VBA code.
 
Back
Top