RE: MS Access 2007: Problem when exporting extended characters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Hi Clifford,

The problem with exporting (TransferText) data containing extending
characters has vasnished.

Nevertheless MSO 2007 with SP2 is in my experience still quite buggy in some
areas. E.g. Copy/Paste from Access to Word produces mixed results with
extended characters. Sometimes Paste into Word (Outlook with Word as email
editor) works. At other times Paste, Special, RTF is the solution. The
codepage in use is 850. This is a minor annoyance (glitch), though.

Again thank you for your effort and time.


Regards,
--
Michael Juul Hansen
Copenhagen, Denmark


"Clifford Bass" wrote:

Hi Michael,

Okay, I am able to replicate the issue! It is indeed related to the
code page, at least as replicated by me. But it is also related to Access.
When you do a text export, and when you get to the export wizard, click on
the Advanced button. There you can specify the code page to use. If I use
"Western European (Windows)" I get "Hillerød". If I use "OEM Multilingual
Latin I" I get "Hiller›d". How does the default value on your computer
compare to the others? If need be, one of the Unicode code pages could be
used--that would hopefully result in the correct characters regardless of the
code page in use by the computer.

Hope that helps,

Clifford Bass

"Michael Juul Hansen, Denmark" wrote:

Hi Clifford,

I'll promptly forward your suggestions and guidance to our inhouse IT
support. We've tried for some time to solve the problem even with external IT
support and searching both the Microsoft Knowledge Base and the Internet as
well. Posting the question here was the latest and hopefully successful try.

Again thank you for your effort.

--
Michael Juul Hansen
Copenhagen, Denmark
.

Quantcast