10 Replies Latest reply on Mar 7, 2011 3:48 PM by brian.curran

    Splitting a large MS Access table and importing into FM

    brian.curran

      Title

      Splitting a large MS Access table and importing into FM

      Post

      Hi,
      I have a large (120+ fields!), messy table in MS Access and have been looking at ways to import the data into FM Pro 11 Advanced. The PK is a 3-digit number that we also use as the Contract No. I'm not convinced that my first attempt at solving this is the best way so I thought I would try to get some advice before going any further.

      I have split the table into 10 separate parts by creating queries to extract information into contacts, addresses, services, suppliers etc. Each query has the same 3-digit PK code and I've exported these to CSV files.

      I'm not sure how to tie all these individual tables back together again using relationships. Do I need to create new FK's then delete the original PK's in these sub-tables?

      Thanks
      Brian.