Solved

Excel 2010 - How can import 9 millions records into Excel from at Text file

Posted on 2013-01-08
6
317 Views
Last Modified: 2013-01-18
I have 9 millions records, can I fit all into Excel or if not, is there other spreadsheet package can do that?
0
Comment
Question by:tommym121
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 48

Expert Comment

by:Martin Liss
ID: 38754919
I don't believe that you can but why would you want to do that? You would be much better off using a database like Access. You could also use a database to supply subsets of the records to Excel.
0
 
LVL 43

Expert Comment

by:Amit
ID: 38754930
Excel won't support this many rows. also chances of data corruption is really high.
0
 
LVL 26

Accepted Solution

by:
redmondb earned 250 total points
ID: 38755098
Hi, tommym21.

Depending on exactly what you want to do with the data, PowerPivot may be the solution for you. (It's a free MS add-on for 2010, built-in for 2013.)

If you haven't come across PowerPivot before, "Top 5 Ways PowerPivot Helps Excel Pros" is a useful introduction. (But skip the cheesy first two paragraphs.)

(BTW, the author mentions that, using PowerPivot, he was working with 97 million rows.)

Regards,
Brian.
0
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 
LVL 6

Assisted Solution

by:yogi4life
yogi4life earned 250 total points
ID: 38758044
Excel 2010 is limited to 1,048,576 rows by 16,384 columns:
http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291



Depending on what you want to do with your data QlikView could be the solution for you. The QlikView Personal Edition is free:

http://www.qlikview.com/us/explore/experience/free-download

QlikView works very well with Excel too - it handles 10 of millions, 100 of millions and even billions of records well - depending on memory, processor and the number of fields... It is in-memory like Excel.

If you check out youtube you will find tutorials to get you started ...
0
 

Author Closing Comment

by:tommym121
ID: 38794894
THanks
0
 
LVL 26

Expert Comment

by:redmondb
ID: 38794919
Thanks, tommym21.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question