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

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

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


.

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.



wrote:

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


.


--

Dave Peterson