Thread: Newbie Access question
03-31-11, 20:10 #1Registered User
- Join Date
- Mar 2011
Unanswered: Newbie Access question
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.
04-01-11, 03:46 #2(Making Your Life Easy)
Provided Answers: 10
- Join Date
- Feb 2004
- New Zealand
first you need to let the database know what is unique in table 1 then you can conpair apple with applehope this help
the aim is store once, not store multiple times
Remember... Optimize 'til you die!
Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
VB-NET based on my own environment started 2007
SQL-2005 based on my own environment started 2008
YOUR PASSWORD IS JUST LIKE YOUR TOOTHBRUSH DON'T SHARE IT.
DONT WORRY ABOUT THOSE WHO TALK BEHIND YOUR BACK
THEY'RE BEHIND YOU FOR A REASON