We Talk Coding
How to compare fields in two dissimilar access databases?
I have two dissimilar access data bases both of which contain a social security number. I need to determine which ssn's appear in both or conversely which do not. I am working in access 2003. I cannot find mention of any compare option so maybe someone could suggest another approach.
Public Comments
- First, check both SSN field property is the same (Text or numeric). If they are the same, you can proceed to step 2. If 1 is text and the order is number (most likely long integer), change th text to number since I am not sure if they are leadin 0's in SSN. Second, go to query section and create new. Pull in both tables and link on SSN field. select whatever field you want to display and click run. All returns will be SSN table is on both tables. for the DO NOT match list, you can click query wizard and select Find Unmatched Query wizard
