display of special characters

M

Martin

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
 
B

Bob Miller

Insert the symbol into a word document and copy it to any text field i
an Access table.
 
J

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.
 
M

Martin

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
 
B

Brendan Reynolds

Which version of Access?

--
Brendan Reynolds

Martin said:
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
Click to expand...
 
B

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

Martin said:
Access 2003.

MM
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for character in a Devanagari Unicode glyph 3
Unicode criteria not working 0
dealing forcefully with Unicode and non-Unicode characters 4
Display of non-printing ASCII characters 1
entering special characters 1
Creating Custom MS-Access Input Masks -- Where can I find the codes to use? 0
Export from xlsx to csv preserving non-german characters 0
Symbol font in report 1

Top