Thanks Duane,
That was my Plan B. I was hoping for a more sophisticated method.
It is a very rare need and has no importance.
Peace, Health and Happiness in 2012
With Wishes for a fabulous New Year full of great achievements and experiences.
Robin Chapple
At 26/11/2011 05:59 PM, you wrote:
>Robin,
>
>I suggest using the un-matched query wizard to find records from one
>table that are not in the other. Use this query as the source for an
>append query.
>
>
>
>If you can't figure this out, come back with both table names as
>well as the fields that make them unique.
>
>
>
>
>
>Duane Hookom
>
>MS Access MVP
>
>________________________________
> > To: MS_Access_Professionals@yahoogroups.com
> > From: robinski@mymail.net.au
> > Date: Sat, 26 Nov 2011 16:35:55 +1100
> > Subject: 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<mailto:MS_Access_Professionals%40yahoogroups.com>
>
> > >From: robinski@mymail.net.au<mailto:robinski%40mymail.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
> > >
> > >
> > >
> >
> >
> >
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>
Tidak ada komentar:
Posting Komentar