Limitation of rows to output

  • Thread starter Thread starter Roy Goldhammer
  • Start date Start date
R

Roy Goldhammer

Hello there

I'm trying to output Query to excel and i gave the error 2306

There are too many rows to output. Based On limitation specified by output
format or by microsoft access

the query has 17000 rows.

What is the limitation and how can i baypass it?
 
Hi Roy,

Export using DoCmd.TransferSpreadsheet, without using the "Save
formatted" option. This allows up to 65536 rows, which is the most Excel
can handle.
 
Whell John

65535 is fine for me. I have problem of outputing more then 10000 rows

I'm using:

DoCmd.OutputTo acOutputQuery, "ObjectName", acoutputxls, , True

Does this structure is limited?
 
Yes, Roy. If you may have more than 16,384 rows you have to use DoCmd.
TransferSpreadsheet acExport...

Whell John

65535 is fine for me. I have problem of outputing more then 10000 rows

I'm using:

DoCmd.OutputTo acOutputQuery, "ObjectName", acoutputxls, , True

Does this structure is limited?
Click to expand...
 
Back
Top