by Michael S. Kaplan, published on 2005/09/15 03:16 -04:00, original URI: http://blogs.msdn.com/b/michkap/archive/2005/09/15/467051.aspx
About a month ago, Ken Skingle asked me about Changing the code page of a text file. I thought I gave a pretty clear answer to the topic. However, the reply I got was the following:
Thanks for reply - do not know what is different as my Access is 2002 and on the advanced tab (import) it comes up as OEM United States automatically.
My problem with wanting to change this to Western Eurpean is that we deal with a lot of mailing data where the characters of names and places have the original country accents, e.g.Lpez, La Corua, Geral De Depsitos Sa, Av Joo Xxi 63, Mller-Rusch, Ra Nueva ,Hnggi, Schifflnde 5, Zrich, lvaro, Jos If this small batch of names is imported as is it does offer Western European(Windows) as the Page Code and they import correctly.
However if these names are contained within a much larger file of various types it offers OEM United States as the code page and on importing it corrupts the unique characters.
eg L≤pez, La Corua, Geral De Dep╙sitos Sa, Av Joπo Xxi 63 Mⁿller-Rusch, Ra Nueva 30, HΣnggi SchifflΣnde 5 Zⁿrich └lvaro
Initially we may not be aware of the different chrs in the data until print time!
So having Western European offered as default would be good. (have screen shots of code page and version if required)
The code page of a text file being imported is selected by an MLang code page detection guessing. I even wrote an article on how to use the same functionality yourself in the April 2000 Visual Basic Programmer's Journal entitled 'Name That Language.' (fee required to see the article, sorry! I do not get any of the money, FWIW).
So there is no way to change the 'default' as that is the encoding being detected, Ken.
There is no default to change. Period.
You have four choices, and ONLY four choices -- take your pick of which one you like:
Hopefully the above is entirely clear at this point. Of the above four options, #2 is the most automatable....
go to newer or older post, or back to index or month or day