Question Mysql 4.1-EXCEL 2013 ODBC connector wrong decoding on export ?

[UknownPavlos]

Hello, i have a problem with exporting data from mysql , it's an old version of mysql 4.0.xx or 4.1.xx. When i am getting data on microsoft query window , they are shown as they have to, but when i am pressing the button to export it on the excel , the decoding is weird. I will post two photos so you can see what i mean.

https://ibb.co/30xSJ26

excel hosted at ImgBB

Image excel hosted in ImgBB

ibb.co

If i export the results from sqlYog into csv , it is shown normal.
Is there any way to fix that , because i want the excel to be connected with the database so i can get the new added data.

 

[UknownPavlos]

UPDATE: Just saw that that db is in latin1_swedish_ci , tried to change it in utf8 , but i am getting the same exports

 

[UknownPavlos]

UPDATE: I am still trying to figure out , i found the query that gives me the right conversion of the text in HEIDIsql11.3.xx

SELECT CAST(CONVERT(subject USING latin1) as BINARY) as SUBJECT FROM tk;

But in odbc connector , i am getting an error like "No columns that Microsoft Excel can use were returned from this query.".