what is the maximum number of rows when exporting query to excel

[Guest]

Hi All:

When exporting an Access table or query to Excel files, the maximum number
of rows is 65535.

However when I tried to export the same query to Excel in Access VBA using
DoCom, it gave me "Run-time Error: 2306", "There are too many rows to export,
based on the limitation specified bye the output format or by by Microsoft
office Accesss?

In Access VGA, how could I export query that could handle the output to
Excel with the number of rows less than or equal to 65535?

Thank you much.

Robert

 

[Ken Snell [MVP]]

Were you trying SendObject method of DoCmd? That has a limitation of 16,384
records.

Use TransferSpreadsheet method of DoCmd instead.

 

[John Nurick]

Were you trying SendObject method of DoCmd? That has a limitation of 16,384
records.

DoCmd.OutputTo has the same limitation, regardless of the output format
you specify.

 

[Ken Snell [MVP]]

DoCmd.OutputTo has the same limitation, regardless of the output format
you specify.

Thanks, John... OutputTo is the method that I was trying to remember, and I
misremembered it!