I have built a new Filemaker solution that I want to import data exported from an old Filemaker file. I have created all the fields in the new solution. There are several hundred fields in the old solution so I though it would be easier to do the data export from the old solution and the import into the new in several passes to keep it from getting unwieldy.
The old and the new both have a serial number field as a primary key (called IDnumber).
A simple example of what I'd like to do if possible:
1. export data to Excel from the old FM solution that includes these fields: IDnumber, name, address, city, state, zip;
2. import this data into the new FM file, which would create new records and add the data to those six fields;
3. export the next set of data: IDnumber, email address, home phone and cell phone;
4. import into the new FM solution - rather than have FM create new records for these next imports, I want to add the data for these fields to the existing records based on the key field.
Is there a straight forward way to do this?