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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Were you trying SendObject method of DoCmd? That has a limitation of 16,384
records.

Use TransferSpreadsheet method of DoCmd instead.
 
Were you trying SendObject method of DoCmd? That has a limitation of 16,384
records.
Click to expand...

DoCmd.OutputTo has the same limitation, regardless of the output format
you specify.
 
John Nurick said:
DoCmd.OutputTo has the same limitation, regardless of the output format
you specify.
Click to expand...

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