Mar 11 2021 11:21 AM
Hello,
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
Sep 28 2021 12:50 PM
@rfdom I installed DB2Connect 11.5 drivers and now have the same issue when values are null.