Strategy for Address Update

[Guest]

Table A has addresses which are updated annually. Table B is from the
database of record (a different system entirely), which is updated
constantly. It is now time to update Table A. What is the most direct
overall strategy?

Factors: The tables share a common field, IDNum. I want to update only the
postal address fields, but not the name field. I can write VB code. I am
using Access 2000.

Thanks!

 

[PC Datasheet]

Create a query that includes both tables joined on IDNum. Include the postal
address fields from Table A. Change the query to an update query. Under each
postal address field, enter the corresponding postal address field from
Table B. When you run the query, the postal address address fields in Table
A will be updated to the data in the postal address fields in Table B.

 

[Ron Weiner]

Link or import the table B from Database B Then run an Update Query

Update TableA INNER Join ON tableB.IDNum = Table SET TableA.Address1 =
TableB.Address1, SET TableA.Address2 = TableB.Address2, ... List all
columns you want to be updated till done

Then run the query.

The last step would be to create and run an Append query to add all records
in TableB that are not in TableA if necessary.

No VB code needed at all.