How do I import TXT file with more than 65,536 rows into Excel?

[Guest]

How do I import a Notepad TXT file with more than 65,536 rows into Excel?

The Notepad TXT file does not have line numbers so is is not easy to find
where the first 65,536 lines end.

 

[Guest]

if it has more thatn 65536 lines, i would import it into
access first. in access, all date beyond 65536 lines would
be put in another table. then the first table would be
downloaded to sheet1 and the second table downloaded to
sheet 2.

 

[Jim Cone]

Ed,

The following is from
http://support.microsoft.com/?kbid=119770

If your worksheet contains more than 65,536 but fewer than 98,303 rows, you can use the Text Import Wizard to import the text file
into multiple worksheets by following these steps: 1. On the File menu, click Open. Select the text file to open, and click OK.
2. In the Text Import Wizard, select 1 for "Start Import at Row," and click Finish.
3. The first 65,536 rows of the text file are imported into a worksheet, and you receive the error message
File Not Loaded Completely
Click OK. Save this workbook.
4. Repeat step 1. In the Text Import Wizard, select 32767 for "Start Import at Row," and click Finish.
5. Note that 65,536 rows of the text file starting at row 32766 are imported into a worksheet. Save this workbook.
6. You can delete the first 32,770 rows in this workbook because these rows were also imported into the workbook you saved in
step 5. Save this workbook.


Regards,
Jim Cone
San Francisco, CA