How do you change the Access exporting output limitation?

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

Guest

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.
 
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
 
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.
 
Back
Top