I have a good sized Access database (>100,000 records) that I'm trying
to put in Excel. I thought that if I broke it into 2 sections, I could
get each half into Excel (with a limit of 65,536 rows). When I tried to
export 57,000 lines of the database into Excel, I got an error message
telling me I had exceeded the limit on number of lines. Have others
seen this, and do you know why this happens? Is there a "real" limit,
other than the 65,536 lines Excel can handle?
Thanks in advance.