View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
keepITcool keepITcool is offline
external usenet poster
 
Posts: 2,253
Default support needed on .CSV file

the problem is:

a CSV file SHOULD only contain only:
linefeeds, quoted fieldentries and listdelimiters.

apparently you WRITE an HTML file and name it CSV.

that would be the same as creating a word document, changing the file
extention to "xls" and expecting Excel to open it correctly.




keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


"Amul Malusare" wrote:

I am creating a .CSV file through ASP (ADODB.Stream)
object and when I view the csv in Excel 2000 its shows the
data well formatted in rows and column (As I am using HTML
Tables to store the Data)

But If I open that .CSV file in 2003/02 its showing all
HTML code in the file.

Please let me know what's the problem is...

Thanks