• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 326
  • Last Modified:

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

I have 9 millions records, can I fit all into Excel or if not, is there other spreadsheet package can do that?
0
tommym121
Asked:
tommym121
2 Solutions
 
Martin LissRetired ProgrammerCommented:
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
 
AmitIT ArchitectCommented:
Excel won't support this many rows. also chances of data corruption is really high.
0
 
redmondbCommented:
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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
yogi4lifeCommented:
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
 
tommym121Author Commented:
THanks
0
 
redmondbCommented:
Thanks, tommym21.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now