Import a large text file

[eran3185]

Hello,

I am trying to import a text file that is 10 millions of rows into excel.
When I import the file, it loads the first 1,048,576 rows. I have tried to import the rest of the file via the From Text Wizard under Data into both a new worksheet and the same worksheet, but the same entries are displayed that were in the original 1,048,576 rows.

Basically I am wanting to get the next 1,048,576 rows of information. How can I do this?

Thanks!

 

[rjwebgraphix]

This article talks about the XL03 and prior limitation of 65536 rows, but the same would apply to latter versions of XL with files larger than their limit.

Importing Big Text Files Into Excel