0

I have this classic ASP code that gets data from a SQL Server database, and then creates an Excel file using Response.ContentType = "application/vnd.ms-excel".

However some of the data has names with accented characters. And when I view the data from the generated Excel file, the accented characters get replaced with other characters like à or ©, etc...

Is there a way I can get the accented characters to display properly?

Thanks

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
omega
  • 40,311
  • 81
  • 251
  • 474
  • try setting the `Response.CodePage` http://msdn.microsoft.com/en-us/library/ms524628%28v=vs.90%29.aspx – Flakes May 16 '13 at 05:34
  • I tried `Response.CodePage = 65001` and `Response.CharSet = "utf-8"`, but it worked on the page if I displayed the contents on the page. However for the excel file, the characters are still messed up. – omega May 21 '13 at 18:49

0 Answers0