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?
-
-
When you say similar formats, you mean they have the same tables names, and column names within the tables?
How to proceed depends on how your relations are set up. There is no simple tool that can do this for you. (Assuming your answer yes to the above question). Once you have a reply to the question I can probably help with some pointers.
Comment