Writing data to a CSV file
I want to send some data from my asp page into a spreadsheet.Fot that I am doing
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.