View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default support needed on .CSV file

Hello

But its opening properly in Excel 2000
and I am facing this problem in only 2002-2003

-----Original Message-----
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


.