Update many fields based on unique identifier

[giddyup43]

Hi.
I have two tables, both of which have the SKU column as the unique identifier. Table 1 has 32,000 records, Table 2 contains an updated version of about 6,000 of these records.
Field names are the same for both tables, it's just the information that is different.
I would like to update the corresponding 6,000 records in table 1 based on table 2.
How do I do it?

Thanks in advance.

 

[Joe4]

Use an Update Query to do so.
Join the two tables in a Query, and the select which fields you want to update and what you want to set them to (the same fields in the other table).
See: https://www.techonthenet.com/access/queries/update2_2007.php

 

[giddyup43]

THANKS SO MUCH!!
That really worked!

 

[Joe4]

You are welcome!