Results 1 to 2 of 2
  1. #1
    ferrets is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    7

    Merging data from two tables

    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.

  2. #2
    Join Date
    Apr 2017
    Posts
    1,673
    Code:
    UPDATE Tbl_Clients clnt INNER JOIN Tbl_Clients_Update upd ON upd.Client_ID = clnt.Client_ID
    SET clnt.Client_Email = upd.Client_Email;

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Merging Two Tables Together. Append Data
    By raychow22 in forum Access
    Replies: 3
    Last Post: 09-01-2017, 05:23 PM
  2. Merging 2 tables
    By dusencha in forum Access
    Replies: 2
    Last Post: 02-24-2014, 11:24 AM
  3. Merging Summaries and Data Tables?
    By anonymous131 in forum Forms
    Replies: 3
    Last Post: 02-04-2013, 03:15 PM
  4. Merging 2 tables
    By todavy in forum Queries
    Replies: 4
    Last Post: 12-02-2009, 10:12 AM
  5. Replies: 8
    Last Post: 11-04-2009, 04:22 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums