Link to home
Start Free TrialLog in
Avatar of tommym121
tommym121Flag for Canada

asked on

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?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

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.
Excel won't support this many rows. also chances of data corruption is really high.
ASKER CERTIFIED SOLUTION
Avatar of redmondb
redmondb
Flag of Afghanistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of tommym121

ASKER

THanks
Thanks, tommym21.