By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,404 Members | 2,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,404 IT Pros & Developers. It's quick & easy.

Moving data from Access to Excel

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
There is a Maximum file size for Excel. I can't remember what it is
off the top of my head, but you may want to search around the Knowledge
Base to find what it is and see if you're reaching it.

Personally, I'd just use a second file....

Nov 13 '05 #2

P: n/a
Thanks for your reply, Chuck. I did a pretty good search online for the
file limit on Excel. Couldn't find it, even at MS site. But I didn't
believe it was under 12M, which is that this file was when I got it
into Excel. I finally found the problem.
I was using "Tools, Office Links, Analyze it with Excel" to convert. I
tried using save as and saving it as an Excel spreadsheet, and it moved
the first 65,536 records into Excel with no problem. I guess the
"analyze" function must do something else that limits the number of
records it can move to Excel.

Chuck Grimsby wrote:
There is a Maximum file size for Excel. I can't remember what it is
off the top of my head, but you may want to search around the Knowledge
Base to find what it is and see if you're reaching it.

Personally, I'd just use a second file....


Nov 13 '05 #3

P: n/a
Oh, indeed! The "Analyze it with Excel" outputs in the "old" Excel
format which is more limited then your version. Prior versions of
Access did the same thing, which limited the number of rows even more.

davegb wrote:
Thanks for your reply, Chuck. I did a pretty good search online for the
file limit on Excel. Couldn't find it, even at MS site. But I didn't
believe it was under 12M, which is that this file was when I got it
into Excel. I finally found the problem.
I was using "Tools, Office Links, Analyze it with Excel" to convert. I
tried using save as and saving it as an Excel spreadsheet, and it moved
the first 65,536 records into Excel with no problem. I guess the
"analyze" function must do something else that limits the number of
records it can move to Excel.

Chuck Grimsby wrote:
There is a Maximum file size for Excel. I can't remember what it is
off the top of my head, but you may want to search around the Knowledge
Base to find what it is and see if you're reaching it.

Personally, I'd just use a second file....


Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.