Combining or merging several tablesIs there a simple way to merge several tables into one. I have an original master table of some data that I would like to add some other tables to and keep the table name the same as my original. The tables to be added have different field names but the data I want to merge is the same (i. e., I would like to keep my original table field names and merge/combine the new tables). I would also like to automate this process to be done weekly on the same tables.
6/24/2011 |