Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Origin Japanese when importing textfiles
Weird problem: Whenever I manually import a textfile into Excel it always
suggest it's file orign to be '932 : Japanese (Shift-JIS)' although I have never used that language in my Windows XP Pro setup - I have no idea why it suggests this. Also the whole file will obviously be imported in Japanese characters if I choose to import it with the suggested language setting. Anyone have any ideas how to change it to default settings ? I'm not using any 'weird' or out-of-the-ordinary text files. The correct format is actually 'Windows (Ansi)', so how do I get Excel to understand that ? Kind regards Rasmus |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
File Origin Japanese when importing textfiles
Rasmus
maybe some registry settings were fouled. probably: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engi nes\Text CharacterSet ANSI (REG_SZ stringvalue) if you have a copy op JETSQL40.CHM on your system (installed with Access) you'll find them the topics explained. else you have to try MSDN Registry Settings for External Data Sources - Initializing the Microsoft Jet 4.0 Database Engine Driver - Initializing the Text and HTML Data Source Driver hth -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam Rasmus wrote : Weird problem: Whenever I manually import a textfile into Excel it always suggest it's file orign to be '932 : Japanese (Shift-JIS)' although I have never used that language in my Windows XP Pro setup - I have no idea why it suggests this. Also the whole file will obviously be imported in Japanese characters if I choose to import it with the suggested language setting. Anyone have any ideas how to change it to default settings ? I'm not using any 'weird' or out-of-the-ordinary text files. The correct format is actually 'Windows (Ansi)', so how do I get Excel to understand that ? Kind regards Rasmus |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing textfiles in Excel 2007 | Setting up and Configuration of Excel | |||
View Japanese Kanji in CSV file | Excel Discussion (Misc queries) | |||
Text file saving, setting file origin | Excel Discussion (Misc queries) | |||
Excel 2002 importing file origin is in japanese... | Excel Discussion (Misc queries) | |||
importing textfiles with cariagge returns into 1 cell | Excel Programming |