August 20, 200817 yr 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
August 20, 200817 yr 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.
Create an account or sign in to comment