My Office has a perverted sense of data... We have been using two different Access DB's that contain some of the workers information (see fake DB) in one DB's and other information in the other DB. Now they want to combine the data from both DB's and use one centralized DB for the good of the group (finally!). Problem is, I am not sure how to combine the missing parts in Table1 and Table2 in to one Composite Table that contains all of the information from both DB's.
I don't want to do this manually if I don't have to there are over 2000 records, but I understand if I have to manually change the ID Field and make those match in the tables. Both tables have incomplete data that needs to be combined in to a separate table. I am just not sure where to get started or is this is even possible. Any help with this would be great. Thanks.
Please see attached file.
CombineThese.accdb