RE: [MS_AccessPros] How do I append only 'new' records.

How would you do this manually?
How do you define "duplicates"?

Duane Hookom
MS Access MVP

To: MS_Access_Professionals@yahoogroups.com
From: robinski@mymail.net.au
Date: Sat, 26 Nov 2011 15:34:28 +1100
Subject: [MS_AccessPros] How do I append only 'new' records.

My group have been building historic records by manually entering

data from several sources.

We now have 30,000 records of posts held by members back to 1921,

very thin for the early years.

Each record is four numeric fields. The SQL is:

SELECT tClubPostHolders.tblClubPostHoldersID,

tClubPostHolders.ClubPostID, tClubPostHolders.MemberID,

tClubPostHolders.YearID, tClubPostHolders.ClubID

FROM tClubPostHolders;

I now have 18,000 records from another source which I plan to append

to the existing table. How do I avoid duplicates?

Many thanks,

Robin Chapple

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/