| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| File conversion-text encoding issue | Excel Discussion (Misc queries) | |||
| UTF-8 encoding CSV | Excel Discussion (Misc queries) | |||
| Choosing a file encoding in VBA | Excel Discussion (Misc queries) | |||
| Excel 2003 and Content-Encoding:gzip | Excel Discussion (Misc queries) | |||
| Prompted to convert the file's text encoding... | Excel Discussion (Misc queries) | |||
Linear Mode
