support needed on .CSV file

[Amul Malusare]

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

 

[keepITcool]

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 >

 

[Guest]

Hello

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

 

[Dave Peterson]

I don't speak the ASP, but if you renamed your file to .htm (or .html), then
opened it via File|open, does that work?

Newer versions of excel work with .html files better than older versions.