Streaming CSV format to Excel 2000/2003 from web

U

usenet

Hi.

Given the following data,

"2002-10-10",6.67,,"3.32",Per Hansen,"Hans Persen",Hanseper
Perhans,"Ting "" ling"
"2002-11-11",6.77,,"4.32",Per Xander,Hans Persen,Hanseper Perhans
"2002-12-12",6.87,,"5.32",Per Diller,Hans Persen,Hanseper Perhans

Sent directly from a website with content type "application/csv", Excel
2000 starts up automaticaly opens it nicely in separate columns and
proper types, while Excel 2003 does not.

Anyone know if there's a way (content type and formatting) that will
work for all Excel versions from 2000 and forward?

Thanks.

Morten
 
D

Dave Peterson

Does this mean that excel2003 doesn't open the file or it opens it, but not in
nice columns?

If it doesn't open the .csv file, I would try reregistering excel.

Close Excel and
Windows Start Button|Run
excel /unregserver
then
Windows Start Button|Run
excel /regserver

The /unregserver & /regserver stuff resets the windows registry to excel's
factory defaults.

If xl2003 opens the file, but doesn't put it in the correct columns:

Could there be a chance that the list separator changed from a comma to
something else (semicolon)???

Close excel
windows start button|settings|control panel|Regional and language options

Click the customize button
Numbers Tab
List separator

Make sure it matches your data.
 
Top