Update 1 table based on a different table

[gearhead03]

I have a customer that send me a file once a month. I can import this into a table. It will have about 10,000 records. I need to write a query that will update two fields in each record in my table to the values from the table that I get from the customer.

How is the best way to do this or what is the best way to set up a query?

Thank You



Mark A. Kale

 

[dhookom]

You can create an update query that joins on the primary key from the imported table to a field in your table.

If you don't have a primary key in the imported table, I'm not sure how you would know which record from the import contains the values to update your main table.

Duane
Hook'D on Access
MS Access MVP