import csv file
 

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

import csv file
 

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

import csv file
 

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

NickHK

"m4nd4li4" wrote in message
om...
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

import csv file
 

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?

--
Cheers
Nigel



"m4nd4li4" wrote in message
oups.com...
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

import csv file
 

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

import csv file
 

Bharesh,
So what do you mean by a "data point" ?

NickHK

"m4nd4li4" wrote in message
ups.com...
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