import csv file

M

m4nd4li4

Hello,

I have csv text files which could contain between 1000 and 50000 data
points. I cannot import this file directly to excel because of 256
column limit. What I want is to transpose the data into a single
column. What is the best way to import this type of file?? (If its any
help, I could mail a typical example).

Regards,

Bharesh
 
M

m4nd4li4

Hi,

Sorry, I did not clarify. In the text file, the data is on ONE single
line. So if I imported into Excel as is, ALL the data would be in one
row only. Can I send you a file???

Regards,

Bharesh
 
N

NickHK

Bharesh,
You mean that you may have up to 50000 columns of data ?
How many records ?

NickHK
 
N

Nigel

The .csv extension on the file will be interpreted by Excel and it will try
to import the file into a worksheet. I would change the file extension and
then parse the text data under a program control. How do you determine the
end of each row?
 
M

m4nd4li4

There does not appear to be anything that would determine end of each
row. Would it be better if I email a file???

Regards,

Bharesh
 

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

Get Standard CSV File 2
Forcing Excel to Import .CSV data 2
CSV-file as semicolon se 2
how to import .csv to excel 1
Import csv to different tables 14
Automate Excel export to a CSV file 1
import csv data in excel using vb 1
Import and Split CSV 1

Top