Error Exporting To Excel

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
 
B

Baz

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trouble exporting Report to Excel 1
too many rows to output 1
output file 3
what is the maximum number of rows when exporting query to excel 3
Exporting records 2
Output Query as an Excel file 2
Exporting To Excel 5
TransferSpreadsheet Issue 1

Top