AnsweredAssumed Answered

Splitting a large MS Access table and importing into FM

Question asked by brian.curran on Mar 7, 2011
Latest reply on Mar 7, 2011 by 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. 

Outcomes