Handling é in Imports/Exports

[LarryP]

In the name of political correctness and diversity, our company has adopted a
particular word that includes the special character é (Alt-0233). We are
finding that sometimes when exporting from Access to Excel or .txt, or
importing from same back into Access, this character gets transformed to a
meaningless symbol. I'm experimenting with setting default fonts to Unicode,
etc., but haven't yet found a solution that will preserve this troublesome
character consistently in both directions. Can anyone offer any wisdom about
how the various MSOffice components handle special characters, and how to get
consistent results when importing/exporting? (We are in a Windows XP/Office
2003 and 2007 environment.)

 

[LarryP]

I'm familiar with the option to set Access to use ANSI SQL, but haven't seen
a setting anywhere to specify the ANSI character set for Excel<-->Access
importing and exporting. I've just assumed that's built into the
Windows/Office environment. Can you point me to how that is done?

 

[LarryP]

Yes, it works SOMETIMES for me too, other times not, haven't been able to
find a common thread that would explain the difference.

I'm familiar with the option to set Access to use ANSI SQL, but haven't seen
a setting anywhere to specify the ANSI character set for Excel<-->Access
importing and exporting. I've just assumed that's built into the
Windows/Office environment. Can you point me to how that is done?

In the name of political correctness and diversity, our company has adopted a
particular word that includes the special character é (Alt-0233). We are

[quoted text clipped - 9 lines]

Make sure you are using ANSI
see http://www.alanwood.net/demos/ansi.html

Larry: I just created a test xls file with an accented e and then imported it
into access from excel.
ID Field1 Field2
1
2
3 233 abcd
4
5
6
7 é

I'm not aware of having set up anything special but it works for me.
XP sp3 Access 2003

--
Message posted via AccessMonster.com


.