Can delimited text file imports be extracted to a single column i.
 

I am trying to import a text file with 50,000 data entries into a worksheet
but the importing function seems to allow only extraction to a single row
which limits the data extraction to 256 data entries. Is there a way to
import with the data formatted to a single column to allow the use of the 64K
rows available to parse the data?

JROD,

It sounds as if the record delimiter isn't what Excel expects. What do you
see when you open the file with a program like NotePad?

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"JROD" wrote in message
...
I am trying to import a text file with 50,000 data entries into a worksheet
but the importing function seems to allow only extraction to a single row
which limits the data extraction to 256 data entries. Is there a way to
import with the data formatted to a single column to allow the use of the
64K
rows available to parse the data?