over 65,000 rows

[Guest]

I have a tab delimited file with well over 65,000 rows. So my Excel 2002
can only open part of the file.

How can I split the file in half so that I load both halves separately in
Excel?

Is there a trick to opening the entire file in Excel 2002?

Jeff

 

[Dave Peterson]

Open your text file in a text editor--Notepad is ok.

Save the top portion as one file and the bottom portion as another file.

You'll bring each portion into excel as separate worksheets.

FYI: xl2007 has over a million rows.

 

[Guest]

Thank you. should have thought of that!

Jeff

Open your text file in a text editor--Notepad is ok.

Save the top portion as one file and the bottom portion as another
file.

You'll bring each portion into excel as separate worksheets.

FYI: xl2007 has over a million rows.

 

[Pete_UK]

Chip Pearson has a macro available here:

http://www.cpearson.com/excel/ImportBigFiles.aspx

which allows you to import large files. It will put the first 64k rows
in one sheet, then the next in another sheet and so on.

Hope this helps.

Pete

 

[Guest]

Thank you very much.

Jeff

Chip Pearson has a macro available here:

http://www.cpearson.com/excel/ImportBigFiles.aspx

which allows you to import large files. It will put the first 64k rows
in one sheet, then the next in another sheet and so on.

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Jeff - thanks for feeding back.

Pete