Use Access w/o coding to update fields in DB 1 with values in DB2?

[Loki13013]

I have a DB that receives its data from daily downloads of a CSV file. The data is loaded into a master table (for example, a record store chain's sales records for multiple locations, with fields "Store ID", "Store Name", "Store total sales&quot. My client would like to add two fields to the master table (for example, "Store Location" and "Store Phone #&quot based on a second table where you can look them up(for example, "Store Name" in the master table has a corresponding value in the second table, and the desired values for "Store Location" and "Store Phone #" are fields in this record). I'm a newbie with no SQL knowledge, how can I create an Update Query as part of my daily "load database" macro to add these two fields to the master table, based on the second table values?

Do I need to setup a relationship? Is there an inner join involved?

You guys have a great forum here. Thanks for this and all the previous assistance.

- B

 

[CliffordTheRedDog]

Loki13013
From what i understand of this question the way i would do it is to have one macro which calls the following
1 import csv file
2 use make table query to add extra empty columns for location and phone number.
3 use update query to propogate the emty columns added with step 2. The store id being the linked field from both tables

I'm not quite sure how this will help as store location and phone number surely relate to one store so where are you saving time/effort? unless this is the data that is static.
Of course, i may have misunderstood what you have said
regards
Cliff