Merging table data (1 Viewer)

[jnh]

Hi,

Have 2 tables:
...TableA: 1 indexed field "Name" and many data fields in ~ 1000 records
...TableB: 1 indexed field "Name" and 2 data fields (DataB1 and DataB2) in about
~ 50 records

Tables currently have NO relationship set.

Want to add TableB data fields to TableA if Name are identical.

DataB1 and DataB2 fields are Not currently in TableA but could be added very
easily.

Update (or whatever) will be done weekly where all previous data for DataB1 and DataB2 will be cleared from TableA before job is run.

Help is highly appreciated...jnh

 

[llkhoutx]

Use an append query.