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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Easy Steps to Import PST Files to Office 365 0
Drag text file to Excel -- stopped working 5
How can I migrate MBOX to PST? 2
Import text file to a SINGLE ROW? 1
text parsing/table creation from single column data 1
Create a single xls file with each import csv file having its own tab 1
Best Tool to Repair Corrupted PDF Files 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Back
Top