too many rows to output

[Guest]

I'm trying this code:

DoCmd.OutputTo acOutputTable, "Table_A", acFormatXLS,
"C:\ExportedTable.xls", False

But I get this error:
Run-time error '2306';
There are too many rows to output, based on the limitation specified
by the output format or by Users Certification.

When I make the export manually, the export works fine. But in runtime
doesn't.

This table has, more or less, 17000 records.

Any help to resolve this?
thanks.

 

[Guest]

Hi again.

After reading some posts I tried the TransferSpreedSheet method and my
problem was solved.

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel9, "Table_A",
"C:\ExportedTable.xls", yes

This works fine and it's more faster.