You will need to key off a common field and replace the bad data in the first table with the corresponding good data from the second table.
Table 1 Table 2
Use a query similar to this:
SET Table1.Address = Table2.Address
FROM Table1 INNER JOIN Table2 on (Table1.Name = Table2.Name)