ODBC Query shows incorrect characters when returned to Excel.

Occasional Visitor


When trying to query from Microsoft Query and return the data to Excel, I am getting strange characters as shown below.




When querying the data directly from Microsoft Query, expected data is returned, as shown below.




If anyone is able to help explain why the data returned via Excel is different than the data returned via Microsoft Query is different, that would be great. We believe it has something to do with the encoding, but don't have any solid leads.


Version 16.0.13530.20490 64 Bit Excel

0 Replies