Error Exporting To Excel

  • Thread starter Thread starter Powderfinger
  • Start date Start date
P

Powderfinger

I get the following error message when exporting a forms record source to an
excel fle.

"There are too many rows to output, based upon the limitation specified by
the output format."

What is an output formatand how do limits get put in it?

The user is selecting "File/Export" when the form is up.

Access 2000


Jack
 
Powderfinger said:
I get the following error message when exporting a forms record source to an
excel fle.

"There are too many rows to output, based upon the limitation specified by
the output format."

What is an output formatand how do limits get put in it?

The user is selecting "File/Export" when the form is up.

Access 2000


Jack
Click to expand...

How many records are in the record source? Excel only supports about 64,000
rows, if you've got more than that then there's nothing you can do about it,
it's simply a limitation of Excel.
 
Back
Top