Merging two databases-combining duplicate references


I want to merge two databases that contain large overlapping duplicate references. While importing I want merge two references that contain some unique information in some of the fields into one. I know this could be done by a copy and paste special command individually. but i want to know if there is any batch merging would possible?

Thank you