Export to excel and special characters

[Tim]

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 C# 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.

-Tim

[Guest]

I am having the exact same error did you ever find a solution. I'd be grateful for any help.

Sam

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 C# 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.
-Tim

User submitted from AEWNET (http://www.aewnet.com/)