View Single Post
  #1 (permalink)  
Old March 2nd, 2005, 06:05 AM
vc1 vc1 is offline
Registered User
 
Join Date: Feb 2005
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Writing data to a CSV file

Hi All,

I want to send some data from my asp page into a spreadsheet.Fot that I am doing

response.ContentType="application/csv"
Response.AddHeader "Content-Disposition", "filename=mydata.csv;"

But the problem I am facing is that, in one of the fields which I want to send to spreadsheet contain commas.Using comma as delimiter creates problem as it splits in between.How can I change the delimiter for the file within an asp page.

Or is there any other solution.


Please help.

Reply With Quote