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

J

JROD

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?
 
E

Earl Kiosterud

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?
 
Top