Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
import file so that it is a actual csv file, no excel cell version | New Users to Excel | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming |