URGENT: Export to excel and special characters

[buzzvishwanath]

I am exporting a dataset to Excel. I can successfully view the dataset in Excel however, there are special characters that are appearing in the form of Â, â€" and others. My code in VB starts off like this: Response.Clear() Response.ContentType = "application/vnd.ms-excel" Response.AddHeader("content-disposition", "attachment;filename=GeneralInquiry.xls") I've tried setting the Response.Charset = "" but that doesn't do anything either. Would anyone know what could be causing this and/or how to fix it? Thank you.

[coolestCoder]

Is it in ASP.NET ? Try using HtmlEncode and HtmlDecode ? This solved my problem for hyphen character.

---

"A good programmer is someone who looks both ways before crossing a one-way street." -- Doug Linder

---

coolestCoder

[leckey 0]

Please read the forum guidelines. Do not use urgent in your message titles.

Current Rant: "Mormon Mania" http://craptasticnation.blogspot.com/[^]

[Paul Conrad]

Please don't use words like urgent. It is consider very rude around here.

"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon