Foreign Language Insertions

[Steve the Paper]

I am compiling a lexicon of paper-making terms in 33 different Europoean languages. The info is created in Word (Office 2000) then dragged into table view in Access. The thing is going well, including Cyrillic's in Russian and Ukrainian, but I cannot get the Georgian font to transfer across, even though I have the Georgian font in my 'central' Office 2000 fonts file. I have taken the words direct from the wwweb and they go into meaningless symbols in Access. I have created them again in Word, character by character via Insert, Symbol, from the menu bar, but STILL they change to meaningless gibbering in Access. If I change the typeface in Access, the whole table changes, so that's no good. Answers anyone? As if you haven't already guessed I am a complete novice, so be gentle with me!

 

[Mile-O]

This is something I'm still learning as I'm trying to write a program with both Latin and Cyrillic characters.

It all depends on what character set you have enabled for your computer.

In the Regional Settings -> Advanced (Windows) tab you can select specific sets for display - some deal with applications while others deal with web viewings.

You pick the ones you want and then it should prompt you to restart your machine. When it reboots your fonts should be installed. Sometimes with character sets (Cyrillic, Arabic, Japanese, Chinese, and Korean spring to mind) you will be prompted to insert your Windows Install disk as, for obvious reasons, most don't install these immediately.

Anyway, what are some Russian paper-making terms? It'll be good for my vocabulary.

If you put some in a reply they'll probably seem like gibberish to most people but my browser is set up to read Russian. Would be nice.

 

[mdjks]

This post was as close as I could come searching for help with multiple languages in Access. I am using Access 2002 to develop some data manipulation and reporting tools . The source data is a report run from SAP. In reviewing the downloaded data I discovered that Vendor names are being entered into SAP in local character sets. This is a global company and the standard installation of fonts includes all necessary languages.

Looking at the file in notepad I am able to see for example ÈÑÒÅÉÒ but once it is imported it becomes gibberish. The default font in all my applications is Arial, I’ve tried changing Access’ font but can’t find one that works. I believe that I am dealing with cryllic and aribic alphabets.

This is the first time I have run across an issue like this, any guidance would be appreciated.

Thanks in advance.

 

[RV]

Not sure but try this.
Import your file using the import wizard.
Click on Advanced.
Set the parameter "Code Page" to Unicode.
Save your import specification.
Make a note of the name you give to your spcification.

See if this solves your problem.
If so, you can build an import mechanism using VBA, inclusing the specification you just saved.

HTH,

RV

 

[mdjks]

Thanks RV, I'll give it a shot in the am and let you know.

 

[mdjks]

Well I tried the unicode option on my import spec, it took 1.5 hours and no data came in. With out unicode it runs in < 30 seconds.