need help

[juan saldivar]

I'm trying to import a large file into excel. It seems
not to care on the length of the record but it only loads
65536 records and gives me the edit message that it
didn't load the whole file. Is there an easy way to get
this file into 2 or more part?

 

[jeff]

Juan,

Sorry.
You'll have to break up your file before importing.
Excel can only provide 65,536 rows and 256 columns.

 

[Dave Peterson]

I'd use my favorite text editor and split the text file into smaller pieces.

Then import them separately.

Or you could use a macro that imports each line:

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q120596
XL: Importing Text Files Larger Than 16384 Rows
(written for xl95, but has a note to change stuff for xl97+)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm