Merging Tables

[Pantelis]

I have a table containing information's (fields) for
products.
Table1 (ProductCode, Info1, Info2, Info3, Info4).

I have a second table containing some of the information's
of the same products of the Table1.
Table2 (ProductCode, Info3, Info4)

The Table2 doesn't contain all of the products of Table1
but he has also some new ProductCode's.

I want to put the data of Table2 to Table1 changing
Table1's where necessary and adding the not existing
ProductCode's.

Tanks in advance,
Pantelis

 

[[MVP] S. Clark]

First, I will strongly recommend that you normalize your tables before
continuing.

I would perform the "syncronization" with several queries. The first query
would be an append query to add any new records from T2 to T1. The second
would be a query to Update any records in T2 that already exists in T1.

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-