Copy/Move data from one large Table to several smaller Tables
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?