Updating new addresses into current client data table

[vangogh228]

I have a client info table (name, address, etc.) with about 3,000 records. I have just been given a spreadsheet with about 100 new addresses for clients withing the database, which I successfully copied to a new table in Access and formatted all the field consistent with the main data table. The key field is SSN. All the fields are named the same, so that shouldn't be a problem. I thought an update query would work, but I don't know how to organize the data in the query, and it appears to me from the reading that an update query is used to change all records to the same data all at once.

My table names are ClientData and NewData.

I am sure I am reading this wrong, and I could sure use some help. Thanks!!!!

 

[The_Doc_Man]

Several ways to skin this cat. (Yes, I firmly believe in the need for feline dermatomy.) I'll mention the easiest way.

What you need is a relationship between the ClientData and NewData fields such that you select all the NewData and only the ClientData that matches.

Now create an Update query to the ClientData table using data from the NewData field. You can do it from the query grid if the relationship is right.

If you aren't sure, look at the SQL to verify that it includes a WHERE clause that says in part .... NewData!SSN = ClientData!SSN .... (or in the other table order, depending on how you actually wrote the query.)

It is that part I showed between ellipsis marks that assures you don't do a wholesale update. If it isn't there in the SQL, you did something wrong in the relationship. DO NOT EXECUTE it.

If you have qualms about it, do it on a copy of the tables first just for practise.

 

[vangogh228]

Guys: Thank you SO much! I will try these suggestions out on some practice data first... but I am pretty sure I get where it's headed. Thanks again! Tom