Thread
:
support needed on .CSV file
View Single Post
#
4
Posted to microsoft.public.excel.programming
Dave Peterson[_3_]
external usenet poster
Posts: 2,824
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
Reply With Quote
Dave Peterson[_3_]
View Public Profile
Find all posts by Dave Peterson[_3_]