Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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? |
#2
![]() |
|||
|
|||
![]()
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Reading a text file ? | Excel Worksheet Functions | |||
save excel file from a table delimited file (.txt) using macros | New Users to Excel | |||
I have a Comma delimited text file how do I import in to excel an. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Convert text file to MS_Excel | Excel Discussion (Misc queries) |