Link from Access to dBase - £ sign won't show in dBase!

[thorwood]

Hi

I have a table in Microsoft Access which I have linked with a table in a program called Create-A-Label3 which uses a dBase III format. All of the data transfers across just fine, except for the £ symbol which is in Access but will not go into the dBase table. It goes in as a weird symbol instead. Is there anything I can do, I need to replace this symbol with the £ symbol.

Thanks
Tim

 

[MiggyD]

Thorwood,

This may be mute, seeing it was asked about a month and a half ago but...

Replace that "weird symbol" with the extended ascii character #156 which you can see for yourself at:

http://www.asciitable.com/

Also, you might want to confirm if that software (Create-A-Label3) will indeed print the ASCII char. If it (Create-A-Label3) can't seem to translate--what appears to me UTF-8 code--to the £ symbol, then run a manual print to test out that. It'd be better than running 5000 labels only to toss them out.

Good Luck.
--MiggyD

My mind not only wanders, it sometimes leaves completely.