Limitation of rows to output

[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?

 

[Guest]

Post the code of the command that export the query for us to look over.

 

[John Nurick]

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.

 

[Roy Goldhammer]

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?

 

[John Nurick]

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?