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

Jumat, 25 November 2011

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

My apology that I failed to express myself clearly.

At 26/11/2011 04:03 PM, you wrote:
>How would you do this manually?

I would need to view each entry in 18,000 records and look for the
same entry in the second set of 30,000 records.

>How do you define "duplicates"?

Where and existing record is "1" "2410" "87" "24"

and the same record set is in the second set of data.

Regards,

Robin Chapple

>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
>
>
>