patternMinor
Merging two Access tables into one
Viewed 0 times
tablesmergingintotwooneaccess
Problem
I have mostly identical tables, however there are slightly differences like missing columns in older ones. I want to merge 5 tables into one. Is there any easy way to do this?
Solution
Create a new table that have all the columne in all your 5 tables, then create the needed SQL statment like SELECT * FROM Tb1 INTO TableWithAllColumns
eventually add some WHERE to exclude the duplicate rows from the insert.
This will work if your table doesent have similar rows.
If you need to merge similar rows together, there is no a simple way to tho this.
The best you can do is find, or write, a tool that can compare all the value in all the columns and act in the right way.
eventually add some WHERE to exclude the duplicate rows from the insert.
This will work if your table doesent have similar rows.
If you need to merge similar rows together, there is no a simple way to tho this.
The best you can do is find, or write, a tool that can compare all the value in all the columns and act in the right way.
Context
StackExchange Database Administrators Q#42729, answer score: 2
Revisions (0)
No revisions yet.