Thread: import csv file
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Nigel Nigel is offline
external usenet poster
 
Posts: 923
Default 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