Issue with MySQL 4.1-EXCEL 2013 ODBC connector during export?

F5F Stay Refreshed Software General Software Issue with MySQL 4.1-EXCEL 2013 ODBC connector during export?

yazaru
Junior Member

05-14-2022, 05:52 AM

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 on 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.

yazaru

05-14-2022, 05:52 AM #1

Aerogel
Member

05-14-2022, 11:37 AM

Updated notice: The database is currently set to latin1_swedish_ci, attempting a conversion to utf8 resulted in unchanged exports.

Aerogel

05-14-2022, 11:37 AM #2

Updated notice: The database is currently set to latin1_swedish_ci, attempting a conversion to utf8 resulted in unchanged exports.

yalex27
Senior Member

461

05-17-2022, 11:05 AM

I'm still working through it, but I found the query that works for converting text in HEIDISql11.3.xx.

yalex27

05-17-2022, 11:05 AM #3

I'm still working through it, but I found the query that works for converting text in HEIDISql11.3.xx.