5 Replies Latest reply on Apr 14, 2017 10:59 AM by Doug Castell

    Converting Excel to dbf with open office changes column headings

    act2gm Apprentice

      Hello community.

       

      Among today's tests in moving from ACT to GM is to import a small set of contacts.  The instructions I found in the training video is to use dbf instead of any of the other formats.

       

      So, I used Open Office spreadsheet to save the exported CSV file from ACT.

       

      When opening the file, Open Office says it is Character Set "Unicode (UTF-8)" and Language "Default - English (USA)"

       

      When exporting to dbf, it wants to save it to "Western Europe (DOS/OS2)-850/International)".  I slide up t o UTF-8 and save.  I then re-open in Open office or Excel and the headers have been changed to what appears to be mapping locations - "N1,C,8" etc.

       

      What am I doing wrong?

       

      John Purdy