Hi,
I'm sure this is very straightforward but would really appreciate some help.
I have two tables. The first was created earlier and includes some basic client details. For example:
Tbl_Clients
- Client_ID
- Client_Name
- Client_Company
- Client_Email (new field)
Another department has then sent me an excel spreadsheet which has all of their client email addresses. They would like these adding to the original table. It includes the original Client_ID from my database.
Tbl_Clients_Update
- Client_ID
- Client_Email
I can easily create a new table by importing the spreadsheet but I'm not sure how to merge the two tables afterwards, so that, where a client_ID matches, the email address is added to the appropriate record in Tbl_Clients. I know that I could link the tables but would rather avoid doing this.