too many rows to output



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

This table has, more or less, 17000 records.

Any help to resolve this?


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.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question