Pulling in spreadsheet content when it contains emojis

[Shedders101]

Hi,

Does anyone have experience of grabbing data from an excel spreadhseet and writing it to web pages when that content contains emojis?
It doesn't work well at all for me. The emojis come in as question marks. I believe they are UTF-8 characters. Do you have to add anything to the usual connection code to make it deal with these types of characters properly? The rest of the text comes in fine.

Original (XLS) file

Result in the page

thanks

 

[Shedders101]

This does it...

<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<%
response.Charset = "utf-8"
objConn.Open "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & DATASOURCE_HERE & ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";"
%>