1 Reply Latest reply on Jul 26, 2013 8:29 PM by taylorsharpe

    Need help reading mdb data from nurse call server

    jvanfossen

      Hello,

      We need help importing the attached mdb data file into FM12 in Windows. The Detail field is encoded, we are told "4-bit binary" by the nurse call system manufacturer. We had some limited success using the Code function, but all of the characters can't be read.

       

      We have played with various ODBC drivers but we are still learning the ins and outs. Any help or direction would be appreciated.

      -- Jim

        • 1. Re: Need help reading mdb data from nurse call server
          taylorsharpe

          When you tried the ODBC drivers, did you test them?  Did you try them with other applications like Excel to confirm that they are working?  FileMaker generally works pretty well with ODBC if the drive DSN is set up properly as a System DSN. 

           

          Alternatively, you can use the FileMaker ODBC driver to have Access connect to a FIleMaker file and you can push data to FileMaker tables.  Remember that Access has a whole bunch of numeric formats.  They work best importing via ODBC into FileMaker as a Number field with no other validations such as field length.  Usually when I first push things, there is a field or two that is a problem.  So I test importing just a few fields at a time with a test set of records and make adjustments as necessary.  Acess will require a primary key for every table and FileMaker does not.  So plan on making sure you create a Primary Key field that is validated as a required field that is unique.