Import German character (Umlaut) ?

[Jan]

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]

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.

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.