Data Synchronization

From: GW (anonymous_at_discussions.microsoft.com)
Date: 09/23/04 

Date: Wed, 22 Sep 2004 18:46:45 -0700

Hi,

I've 2 tables namely tblA and tblB of which have the same
structure. Currently, tblA having 10000 rows and it's
using autonumber. The problem are as follows :-

1) How to append data from tblB which are not exist in
   tblA and the new row should follow the autonumber
   in sequence i.e from 10001 ?

2) How to overwrite data in tblA which exist in tblB
   without any changing to the autonumber field.

3) Is it possible to combine the above into one query ?

Thanks.

Relevant Pages

  • Re: Update all records in VBA
    ... there's still some unique ID that is consistant in tblA and tblB after the ... are then stored in tblParts. ... doing the import and update tblA and tblB in VBA. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Trigger After Delete - I need a Trigger Before Delete
    ... I have a table tblB which has to be filled whenever in table tblA ... This view vwC is based on a key field used in tblA. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • RE: SQL question - compare 2 tables
    ... To find which entries are in tblA but not in tblB, ... > of the parts in tblB may be missing. ...
    (microsoft.public.access.queries)
  • Strange behavior on query - Help??
    ... I have tblA with unique PrimaryKeyX. ... Then tblB has many PrimaryKeyX matches, and for each there is a fieldY ...
    (microsoft.public.access.queries)
  • Re: Option Group
    ... Yes they have the same feilds and since thay have the ... same feilds on bother tblA anf tblB I have decided to may ... Option Group: ...
    (microsoft.public.access.forms)