xls, txt encoding
When pumping data to Excel via ODBC there is no way to change charset - MS Querry crashes when trying to. As a result I can see gibberish (instead of expected Polish).
Well, if I save the sheet with imported "corrupted" data as a txt file and open in Notepad it looks fine.
Opening that file again in Excel (using text import wizard and changing encoding to UTF-8) produces also good result. Obviously I'd like to avoid this workaround or at least automatise it with script, macro, whatever.
Any tips?
Regards
Jarek
|