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.
 

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

Similar Threads

output file 3
Output Query as an Excel file 2
Excel Output Error - Newbie Help 4
Access export to Excel stops at about 45,000 not 65,000 XL limit 11
Too many rows to Output 4
Limitation of rows to output 4
Solution: Error 2306: There are too many rows to output (Access to Excel using OutputTo) 1
Error: Too many rows to output? 2

Back
Top