support needed on .CSV file
 

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

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

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


.

support needed on .CSV file
 

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