Merge multiple Excel files

Merge multiple Excel files

Hi, i have about 10 different excel files that i need to import into my act database.

In each file there is one column that is the key column, Its called the 'Site ID". What i want to do is import file one. Then when i import file 2 i want ACT to see only that one column "Site ID" and merge the data into the fields instead of creating a new record. Basically just update the record with any additional fields. Each spreadsheet has additional information for each record.

The question is how to i tell ACT that "Site ID" is the only field i want it to use to determine if it already exists or if its a new record?

Re: Merge multiple Excel files

The ACT! import won't work for what you want to do. The merge in the ACT! import won't update existing data data in fields, only fill empty fields. You need a third party utility like OakMerge to do what you want.