Open a CSV how God meant it
Hello, cyberfriends.
Excel has a nasty habit of assuming that all CSV (comma-separated) files are in ANSI format, i.e. no extended characters. If you happen to have a CSV file that is Unicode or UTF-8, this ends in tears, because things like accented characters turn into hideous question marks. It is possible to "import" the file, and go through about six pages of settings and options, and select Unicode or UTF-8 at some point. But nobody I know can bear to do this, especially if they are generating the files on a daily basis. Does anybody have a macro or something that can open a Unicode or UTF-8 (or whatever non-ANSI encoding) CSV file in Excel? I would love such a thing. Eq. |
Open a CSV how God meant it
Have you tried recording a macro while doing the import manually ?
Tim "Paul E Collins" wrote in message ... Hello, cyberfriends. Excel has a nasty habit of assuming that all CSV (comma-separated) files are in ANSI format, i.e. no extended characters. If you happen to have a CSV file that is Unicode or UTF-8, this ends in tears, because things like accented characters turn into hideous question marks. It is possible to "import" the file, and go through about six pages of settings and options, and select Unicode or UTF-8 at some point. But nobody I know can bear to do this, especially if they are generating the files on a daily basis. Does anybody have a macro or something that can open a Unicode or UTF-8 (or whatever non-ANSI encoding) CSV file in Excel? I would love such a thing. Eq. |
All times are GMT +1. The time now is 03:20 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com