I succeeded doing this with a 3 column, 270000 line text file. I'll try it
with your file if you want to zip it up and send it to me.

--
Jim
"jason2444" wrote in message
...
| have a text file that is a little over 250,000 lines and will be 13
columns
| wide. I can open the whole file in excel but if I try and import it using
,
| as a delimiter to put all the text in the right columns it says file is to
| large for on sheet. and will not let me import the whole file. any one
have
| a solution so i can import the entire file? or have any suggestion why
this
| is happening?