too many rows to output

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

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.
 
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.
 
Back
Top