ODBC Query shows incorrect characters when returned to Excel.

%3CLINGO-SUB%20id%3D%22lingo-sub-2203200%22%20slang%3D%22en-US%22%3EODBC%20Query%20shows%20incorrect%20characters%20when%20returned%20to%20Excel.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2203200%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EWhen%20trying%20to%20query%20from%20Microsoft%20Query%20and%20return%20the%20data%20to%20Excel%2C%20I%20am%20getting%20strange%20characters%20as%20shown%20below.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rfdom_2-1615490082715.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262864i3A12C4CC305DCA9E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rfdom_2-1615490082715.png%22%20alt%3D%22rfdom_2-1615490082715.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20querying%20the%20data%20directly%20from%20Microsoft%20Query%2C%20expected%20data%20is%20returned%2C%20as%20shown%20below.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rfdom_3-1615490158341.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F262865i32A251674CFF5B74%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22rfdom_3-1615490158341.png%22%20alt%3D%22rfdom_3-1615490158341.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20anyone%20is%20able%20to%20help%20explain%20why%20the%20data%20returned%20via%20Excel%20is%20different%20than%20the%20data%20returned%20via%20Microsoft%20Query%20is%20different%2C%20that%20would%20be%20great.%20We%20believe%20it%20has%20something%20to%20do%20with%20the%20encoding%2C%20but%20don't%20have%20any%20solid%20leads.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EVersion%2016.0.13530.20490%2064%20Bit%20Excel%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2203200%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDeveloper%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

Hello,

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

rfdom_2-1615490082715.png

 

 

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

 

rfdom_3-1615490158341.png

 

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