1 2 Previous Next 21 Replies Latest reply on Jul 2, 2012 1:46 PM by brian.curran

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

    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.

        1 2 Previous Next