Re: Import German character (Umlaut) ?

Tech-Archive recommends: Speed Up your PC by fixing your registry

Hi Jan,

If none of the available character sets fixes it then there's no really
simple way.

Is it possible to tweak the software that's producing the file (I guess
it's a text file) you're importing? If not, it's easy in recent versions
of Access to change ] to Ü (U-umlaut) by using an expression like this
in an update query:

XXX: Replace([XXX], "]", "Ü")

- but of course this will also replace any genuine right-brackets. For
that matter, it's conceivable that what's being displayed as ] is
something other than the usual ]. As far as I know the latter is
represented in all the usual character sets by either the one byte 5D or
the two bytes 005d; you may need to use a hex editor to find out just
what's in the file.

On 10 Sep 2006 23:43:23 -0700, "Jan" <janoleolsen@xxxxxxxxxxx> wrote:

Is there a simple way of importing J]RGEN so it becomes U with dots
instead of ]. I see there are many character sets in the Access Import
Wizard, but don't find any that makes it correct.

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.