I'm attempting to merge multiple Access databases into one. They are all of the exact same format but with different datasets. Using the append tool, I can get all of the data into a single database, but the relationships are lost. Does anyone know how to append related data from multiple tables?