Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011

    Unanswered: Newbie Access question


    I have two Excel files that both contain the same columns:

    First Name
    Last Name
    Street Address

    File 1 is my master file and contains thousands of records.

    File 2 contains a lot of records that are already in File 1 but it has more updated information for some records - for example, a Zip code might be missing for "Joe" in File 1, but it is populated in File 2.

    File 2 also has some new records which are not on File 1.

    But File 1 has much more data than File 2.

    Here's what I want to do:

    1. For any fields NOT populated in File 1 but populated in File 2 for the same record, I want to update File 1 with the information (ie - Zip code for Joe).

    2. For any records that exist in File 2 but not in File 1, I want to bring them into File 1.

    3. I want my matching criteria between the two files to be FIRST NAME and LAST NAME. Therefore, if those two fields match for any given record in the two files, then I want the information in File 2 to UPDATE the information in File 1. By update, I mean - don't touch fields in File 1 where data exists, but add information in any fields which are blank in File 1 but populated in File 2.

    I tried to do this in FileMaker and it took me about 2 seconds using the Import Data command and telling it which fields I wanted to match.

    I'm trying to do the same thing in Access but can't figure out how. I keep reading about Action Querys and it all sounds wildly confusing.

    Please help!

  2. #2
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 10
    first you need to let the database know what is unique in table 1 then you can conpair apple with apple
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts