display of special characters

[Guest]

Dear experts,

can Access save non-ANSI characters, i.e. Unicode characters, in particular
Greek symbols? The 'Delta', for instance, has the (Word specific) number 948
and can be displayed in a word- and text-file, but apparently not in an
Access-table.

Thank you

Martin Mueller

 

[John Spencer]

Access 2003 can store non-ansi characters.

I just put a capital lamda into a table field - font being used was Arial
Regular. I'm not sure how you are attempting to get the data into the
field. My simple test was to copy the character from a word document.

I believe the ability to do this started with Access 2000.

 

[Guest]

The problem occurs while using the menu option 'import table', the table
being a text-file which supports Unicode characters.
I first transform a large Word-table to a Unicode-text file (columns are
separated by tabs) then import it to Access, I think, it is the way to do it,
but am open for other hints, since I have not enough (that means: no)
experience in Access.

Thank you

Martin

 

[Brendan Reynolds]

Which version of Access?

--
Brendan Reynolds

The problem occurs while using the menu option 'import table', the table
being a text-file which supports Unicode characters.
I first transform a large Word-table to a Unicode-text file (columns are
separated by tabs) then import it to Access, I think, it is the way to do
it,
but am open for other hints, since I have not enough (that means: no)
experience in Access.

Thank you

Martin

 

[Guest]

Access 2003.

MM

Which version of Access?

 

[Brendan Reynolds]

OK, that eliminates one possible cause of the problem - you are using a
version of Access that does support Unicode.

Could you provide steps I could follow to try to re-produce the problem? For
example, how do you get that particular character in Word, and how are you
transforming the Word document to a text file?

--
Brendan Reynolds

Access 2003.

MM

 

[Guest]

I have checked out the steps, and the problem is solved.
When saving the word-file as a text file, I have to choose as coding
'unicode' NOT 'unicode-UTF-8'. After having made sure, that the character in
Word itself is a MS Unicode character, not a 'symbol', i.e. it must have a
positive CharNum in Word.

Thank you
Martin