Solved

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

Posted on 2013-01-08
6
314 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 47

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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
INSERT value into first row in 75 workbooks 8 37
need help to look for 16 42
Embed Excel WS into PPTX 4 26
How to turn this IF statement into a UDF? 5 20
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

734 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