Import of DBF shows wrong chars

Discussion in 'Access Conversion' started by Sascha Nitsch, Feb 10, 2010.

  1. 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
     
    Sascha Nitsch, Feb 10, 2010
    #1
    1. Advertisements

  2. Sascha Nitsch

    poppsnchopps Guest

     
    poppsnchopps, Apr 9, 2010
    #2
    1. Advertisements

  3. Sascha Nitsch

    poppsnchopps Guest

     
    poppsnchopps, May 20, 2010
    #3
    1. 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 (here). After that, you can post your question and our members will help you out.