AnsweredAssumed Answered

Importing data from old database

Question asked by kentanderson on Feb 14, 2014
Latest reply on Feb 15, 2014 by kentanderson


Importing data from old database


     In my old Access Database We only had one table.  So each record contained all of the client data Name address etc. My new better FM database has a client table and a jobs table.  My jobs table contains all of the same fields as my old with one exception.  My new data base does not store all to the repeating client data, instead I just have a Client ID field.  

     How can I import my old data, and somehow link the old data jobs to the new client Id in my new database?

     I typically copy my old database from Access and paste it into a excel spreadsheet.  FYI

     Thank You