Combining two simple databases

[Johnny777]

Hello everyone

I have two simple databases I need to combine. The smallest one is a list of email addresses and one other text field. I need to import these into a larger database of contact addresses

Where the email address already exists in the target table then no import needs to take place. ie a new record is added only where the imported email address does not already exist in the target table. As there are 1200 records to import I am trying to avoid endless find requests

Thanks for reading

[corn]

Easy as pie.

When performing your import, select the option to "Update matching records." Then, click the arrow between the email address fields in the Specify Import dialog to show a double-arrow, indicating the fields FMI should use to "match" records. Finally, near the bottom of the dialog, check the box to add new records if no match.

[Johnny777]

That has worked fine

Thanks very much