How do you change the Access exporting output limitation?

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.
 
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
 
G

Guest

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.
 

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

Top