Too many rows to Output

[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 ?

 

[John Nurick]

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.

 

[Guest]

Thank you.

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.

 

[Guest]

Can you please explain how I go about using DoCmd.TransferSpreadsheet (rather
than DoCmd.OutputTo). i.e. Where / How I specify this..?
thanks

 

[John Nurick]

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.