Results 1 to 2 of 2
  1. #1
    vetabz is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jan 2017
    Location
    Philippines
    Posts
    13

    Lightbulb Only import unique records

    Hi All,

    Basically, I just wanted to know if this is possible and if it is how could it be done.



    The scenario.

    1. I import an excel file (see First Import from the image below)
    2. Later on, I did another import but based on my example only 1 record did change and that is
    record id #2 where category has changed.

    What I wanted to do is not overwrite everything only record #2 so that the final result would
    be like the "Result in Access" portion of the screenshot.

    Click image for larger version. 

Name:	import_to_access.PNG 
Views:	9 
Size:	6.5 KB 
ID:	27128

  2. #2
    vetabz is offline Novice
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jan 2017
    Location
    Philippines
    Posts
    13
    I found the solution, please don't bother. thanks.

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

Similar Threads

  1. Replies: 1
    Last Post: 03-13-2014, 05:30 PM
  2. 2 Records of unique field name
    By tonydepo in forum Queries
    Replies: 5
    Last Post: 03-20-2012, 11:40 AM
  3. Count Unique Records
    By PonderingAccess in forum Queries
    Replies: 2
    Last Post: 08-19-2010, 06:54 AM
  4. Need Help Summing UNIQUE Records
    By Millerguitarworks in forum Access
    Replies: 5
    Last Post: 05-27-2009, 04:37 PM
  5. query that will contain all unique records
    By halcolm1 in forum Queries
    Replies: 0
    Last Post: 01-19-2007, 05:34 PM

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