Results 1 to 3 of 3

Append data from one table to another table

  1. #1
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28

    Append data from one table to another table


    I have two tables that are nearly the same with identica fields but one table does not have data in3 new fields that were added to it. I added the 3 new fields to the other table but those fields are empty currently. I want to APPEND the data in the new fields to the other table with the fields that I added to it (named a designed the same as the first table. How can I append the data from those fields to the second table?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,254
    Run an UPDATE query.

    Why do you have two identical tables?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cmiyatake is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    28
    Quote Originally Posted by June7 View Post
    Run an UPDATE query.

    Why do you have two identical tables?
    I want to preserve the origina table

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

Similar Threads

  1. Append data into a table
    By johnseito in forum Access
    Replies: 8
    Last Post: 08-14-2019, 08:51 AM
  2. I need append data from table to another
    By hosni4eg in forum Access
    Replies: 5
    Last Post: 05-15-2017, 08:08 AM
  3. Replies: 4
    Last Post: 01-20-2015, 12:55 PM
  4. Replies: 1
    Last Post: 11-16-2014, 09:10 AM
  5. Data append to table
    By ali zaib in forum Access
    Replies: 4
    Last Post: 01-13-2012, 11: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
  •  
Tech Forums: Microsoft Office Forums