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

Jumat, 25 November 2011

[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