ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   xls, txt encoding (https://www.excelbanter.com/excel-discussion-misc-queries/170311-xls-txt-encoding.html)

JU

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


All times are GMT +1. The time now is 08:49 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com