I have two Excel files that both contain the same columns:
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.
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
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 MYLE YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.