How do you change the Access exporting output limitation?

D

Di

I am getting a message when exporting an Access Report of 400+ pages to
EXCEL. The message states that I have exceeded the output limitation in
ACCESS. Can the specified limitation be set higher? I know I am not going
over 65,000 lines, which is the EXCEL row limitation. I am using the Access
version from Microsoft Office 2000.
 
T

Terry

Di,

A report to excel????????

Are you sure?? Or are you exporting a table or query?

Some detail on what steps you are taking to perform the
export might help.

Terry
 
C

chuck

It may not be the excel 65000 limit, but a record length limit. Check if
your only sending 1 record. If so, be sure you export with required tab
delimit.
 
Top