473,326 Members | 2,133 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

Moving data from Access to Excel

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
3 3602
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
1
by: Steven Stewart | last post by:
I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...
3
by: Mads Petersen | last post by:
I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....
0
by: Jack | last post by:
Windows 2K Pro Access/Excel 2003 Hi there, I have a large number of password protected Excel Workbooks. The files are protected by code that runs when the workbook opens. The code asks the...
11
by: Hi5 | last post by:
Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, ...
0
by: Grip | last post by:
Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...
5
by: mtgrizzly52 | last post by:
I am running an access 2003 dbase that has been slowly developed for use on a network. (I know, should be sql, but our IT dept won't allow that to happen, so we are stuck) Anyway, because of the...
7
by: semijoyful | last post by:
OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on a form where users can input data in Access and...
3
by: =?Utf-8?B?YzY3NjIyOA==?= | last post by:
Hi all, I have a question for you. I have a .csv file which has many lines of data. Each line has many data fields which are delimited by ",". Now I need to extract part of data from this...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.