> Hi; > > > > If I have a text file with huge data and need to open it through the > excel what should I do? if the number of rows in the text file which I have > more than 10 million, and as you know the capacity for excel 2007 is one > million approximately, So please advice ? > > IMHO if you have that much data then spreadsheets are not really what you should be using. I would suggest a data base (eg, MySQL) would be better suited.
I'm unsure if even base could support that amount of data - importing it would be a little tricky. If however you are stuck on using calc/excel I would suggest that you write a macro to open the text file and import line by line into each row. Once you get to 1 million rows, create a new sheet and start again. You'll end up with your data spread across ~10 sheets. HTH, /paul
