Migration options

[eenus1]

Hello

We have 60 fp7 files, generally with one table per file, the data (not worried about functions/layouts etc) needs to be migrated to a new database (in existence and designed). These files have been created in previous versions of FMP and one or two contain large numbers of fields (720). I'm using FMPro 8 Advanced.

What is the best way to migrate the data and perform the field mappings/transformations? Write scripts in destination/source or an intermediate file? Import seems not to be able to sort source fields and I get in one Import Records step no source fields viewable.

Hope this explains the situation.

Thanks