Table/Query Troubles

[Guest]

I was given the task to take some 'contacts' in Outlook and put them on a
database. Transfering the data to an access table was easy. The tricky bit
is that the Outlook contacts are regularly updated and i need to keep
transferring them to the same database. How do i transfer the Outlook
contacts without duplicating the existing records (as thay are updated in the
new database)... Essentially I think i need to do a query that only shows the
new contacts from Outlook, and from there i will add them to the database.
What makes it more difficult is that the outlook contacts are not in the best
order and different fields are filled in per person, i.e I cant have a
primary key or search for duplication on one field as some records wont have
anything in this field... its really bugging me as it seems like such an easy
thing to do but i keep running into problems when i think i've solved it...
cheers for any ideas.

 

[Guest]

You could export the contacts to excel. Create a linked table from the excel
file. Create an append query that would just add the new data each time.
That is probably the most complicated way to do it, but it would work.