AnsweredAssumed Answered

Copy/Move data from one large Table to several smaller Tables

Question asked by brian.curran on Jun 27, 2012
Latest reply on Jul 2, 2012 by brian.curran

Title

Copy/Move data from one large Table to several smaller Tables

Post

Hi,
I'm getting quite close to finishing off a new database and would like to load up some real data from our existing MS Access database in order to test it all out before going live.

I created a 133-field Query with approx. 200 records and exported it to a CSV file. This file has been imported as a 'recurring import' into a new Table in FM Pro 12 Advanced.

I'm now stuck as I need to separate out the 133-fields and copy/move the data into existing FM tables. Can anyone suggest a good method to achieve this?

Thanks
Brian.

Outcomes