Import of DBF shows wrong chars

[Sascha Nitsch]

Dear all,

we need your help. We have the following situation:
We are using MS Access 97 on a Win2k machine. What we plan to do is
import our warehouse data (which comes out of an old DOS system named
GandkeSchubert 2.6). This saves all data as DBFs.

When importing the DBF to Access (either with DBASE III, IV or V
setting) we have a problem with a special field. To take one example
that we realised: Access interprets one value as "ÈäÇÇ+-" whereas the
original entry in the DBF is "ÈäÇÇâ”-". I assumethat this is related
to one of the drivers Access is using, meaning ASCII or something. Of
course we can't forsee which characters are also miss-interpreted as
this is only one example we found!

Can anybody help on how to change setting of import or character set
to avoid this?
Thanks upfront.
Sascha

 

[poppsnchopps]

Dear all,

we need your help. We have the following situation:
We are using MS Access 97 on a Win2k machine. What we plan to do is
import our warehouse data (which comes out of an old DOS system named
GandkeSchubert 2.6). This saves all data as DBFs.

When importing the DBF to Access (either with DBASE III, IV or V
setting) we have a problem with a special field. To take one example
that we realised: Access interprets one value as "ÈäÇÇ+-" whereas the
original entry in the DBF is "ÈäÇÇâ”-". I assume that this is related
to one of the drivers Access is using, meaning ASCII or something. Of
course we can't forsee which characters are also miss-interpreted as
this is only one example we found!

Can anybody help on how to change setting of import or character set
to avoid this?
Thanks upfront.
Sascha

 

[poppsnchopps]