Import of DBF shows wrong chars


S

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
 
P

poppsnchopps

Sascha Nitsch said:
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
 
Ad

Advertisements


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

Top