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" <[email protected]> wrote in message
news:[email protected]...
>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?