![]() |
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