Jsw469
asked on
Combine multiple databases
I have multiple database that I need to combine into 1. They all have the same password to open and all have the same structure. I need to combine all the data in all the tables.
You can choose one of your databases and then link the tables from the others to it. Just right-click in a blank area of your tables and select link tables.
Flyster
Flyster
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Jsw469,
Another question is if this is a one time situation and after you combine all, will you have to repeatedly combine them, or will you be able to work with the combined set in the future. This can be done fairly easily for a one time, few databases/tables scenerio, but can get complicated if there are very many.
Bob
Another question is if this is a one time situation and after you combine all, will you have to repeatedly combine them, or will you be able to work with the combined set in the future. This can be done fairly easily for a one time, few databases/tables scenerio, but can get complicated if there are very many.
Bob
How many databases and tables in each, are there?
Will you append all the records or will there be some duplicates that need attention?
Bob