Comparing two tables and updating one of them

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

Could someone explain how I can go about comparing two identical tables and updating one with the missing information found

I have two tables. One got updated by some people and the second was updated by others. I want to combine all the data into one table without creating duplicate entries. As such, I would like to create a query that will review/compare the two tables and then transfer any new info into one master table. Either create an entirely new table or simply update one of the two original table so that it contains all of the data

Thank you for your help

Daniel
 
Hi Daniel,

I think you need to elaborate on the logic a little. What if you have the
following:

TABLE1 TABLE2
LastName LastName
"Smith" "SmithX"

Which value is the correct value?


Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights



--------------------
| Thread-Topic: Comparing two tables and updating one of them
| thread-index: AcQiQK39o0qa/aZFTMC+FZO4gCEv4g==
| X-WN-Post: microsoft.public.access.queries
| From: "=?Utf-8?B?RGFuaWVsIFA=?=" <[email protected]>
| Subject: Comparing two tables and updating one of them
| Date: Wed, 14 Apr 2004 09:51:06 -0700
| Lines: 9
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:197373
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.queries
|
| Hello,

Could someone explain how I can go about comparing two identical tables and
updating one with the missing information found.

I have two tables. One got updated by some people and the second was
updated by others. I want to combine all the data into one table without
creating duplicate entries. As such, I would like to create a query that
will review/compare the two tables and then transfer any new info into one
master table. Either create an entirely new table or simply update one of
the two original table so that it contains all of the data.

Thank you for your help,

Daniel
|
 
I am in this boat -- this may be impossible, but I'm trying to establish a
change log where I can find all the differences in the data in the
"post-processing" table compared to the "pre-processing" table -- e.g.
TABLE1 vs. TABLE2 a list of all the data elements such as SmithX that are
different -- is this possible?

S. Liza Hockridge
Centtric Marketing Systems
 
Hi Daniel,

Ok so what if you have:

TABLE1 TABLE2
LastName LastName
"Smith" "Smith"
"Doe"
"Jackson"
"Williams" "Williams"

The answer I'm seeking is which one would be the correct one? If you were
approaching this from a manual approach which record would you choose and
why?

Once you have an answer for the above then it should be easy to implement
whatever needed logic.

Regards,

Eric Butts
Microsoft Access Support
(e-mail address removed)
"Microsoft Security Announcement: Have you installed the patch for
Microsoft Security Bulletin MS03-026? If not Microsoft strongly advises
you to review the information at the following link regarding Microsoft
Security Bulletin MS03-026
<http://www.microsoft.com/security/security_bulletins/ms03-026.asp> and/or
to visit Windows Update at <http://windowsupdate.microsoft.com/> to install
the patch. Running the SCAN program from the Windows Update site will help
to insure you are current with all security patches, not just MS03-026."

This posting is provided "AS IS" with no warranties, and confers no rights


--------------------
| Thread-Topic: Comparing two tables and updating one of them
| thread-index: AcQiVaJPfz3TKWwLRjGhwuhXx/+oLA==
| X-WN-Post: microsoft.public.access.queries
| From: "=?Utf-8?B?RGFuaWVsIFA=?=" <[email protected]>
| References: <[email protected]>
<[email protected]>
| Subject: RE: Comparing two tables and updating one of them
| Date: Wed, 14 Apr 2004 12:21:06 -0700
| Lines: 7
| Message-ID: <[email protected]>
| MIME-Version: 1.0
| Content-Type: text/plain;
| charset="Utf-8"
| Content-Transfer-Encoding: 7bit
| X-Newsreader: Microsoft CDO for Windows 2000
| Content-Class: urn:content-classes:message
| Importance: normal
| Priority: normal
| X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
| Newsgroups: microsoft.public.access.queries
| Path: cpmsftngxa06.phx.gbl
| Xref: cpmsftngxa06.phx.gbl microsoft.public.access.queries:197421
| NNTP-Posting-Host: tk2msftcmty1.phx.gbl 10.40.1.180
| X-Tomcat-NG: microsoft.public.access.queries
|
| Eric,

Such a case should never occur. Either the data will be the same or there
will be no data in one of the two tables. Never should there be different
data in the same field.

Hope this help,

Daniel
|
 
Back
Top