Compare Database

[nik.be]

Hi there,

This is my problem:

I have 2 contact databases (CLIENTS and AGENCIES).

Each DB contains pretty much the same fields (name, last name, address, city, postcode...).

I need to compare these 2 DBs so that I can find any duplicate contact details and remove them.

The favorite option would be compare AGENCIES to CLIENTS and remove any duplicate from the AGENCIES DB.

Please let me know if this is clear as mud.

Thanks

NikBe

[mr_vodka]

It depends on what you consider a duplicate. you can create a relationship between the two files to compare your fields / combo of fields (concatenated or directly ). You can mark which ones are duplicates in the other file, omit them and then import into your first file.