Results 1 to 6 of 6
  1. #1
    a.phoenix is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2017
    Posts
    17

    How to import data from table 1 to table 2

    dear All



    I want to import one data from Table 1 into Table 2 But i want only the new row like
    I have 2 Table ; 1 table is about student individual and this table will record the current school and I have another to record School history of the student.

    My point I want to create button to help user to import the current school into school history (look at the image) so please somebody tell me how can I do it?

    Thank you.
    A. Phoenix
    Attached Thumbnails Attached Thumbnails Presentation1.jpg  

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    append query.
    choose the source record (via key) and add to the target table.

    the button would execute:
    docmd.openquery "qaAdd1Record"

  3. #3
    a.phoenix is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2017
    Posts
    17
    Thanks for your answer, can you show me like the picture. I'm not sure I understand at all.

  4. #4
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    I think you want to only add the current record that does not yet exist in school history table, is that correct? If yes you need to create an append query as ranman said, but use left outer joins (arrows pointing from the student individual table towards the school history table) between the student ID and school and in the fields coming from school history (student and school) you put Null as the criteria.

    Cheers,
    Vlad

  5. #5
    a.phoenix is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Oct 2017
    Posts
    17
    Thank you,

    Your answer helped me, it help me a lot.

    A. Phoenix

  6. #6
    Gicu's Avatar
    Gicu is offline VIP
    Windows 8 Access 2013
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,101
    Glad to hear! Good luck with with your Access projects!
    Vlad

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

Similar Threads

  1. How to import data to the back end table.
    By kacocal in forum Import/Export Data
    Replies: 6
    Last Post: 02-15-2016, 12:04 PM
  2. Replies: 13
    Last Post: 01-25-2016, 01:36 PM
  3. Import(copy) data from another table
    By tazzzz in forum Import/Export Data
    Replies: 16
    Last Post: 09-17-2015, 11:55 AM
  4. Replies: 4
    Last Post: 03-19-2015, 06:14 PM
  5. Possible to Import data and replace some, but not all, in table?
    By IncidentalProgrammer in forum Import/Export Data
    Replies: 2
    Last Post: 02-17-2015, 09:30 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