Append Multiple Tables with varying names into one
Posted on 2009-06-30
i have many tables that i've imported from an excel sheet wih tabs. I already did the code so that each tab has its own table name. i want to be able to consolidate all those tables into one.
i have auto named the tables BC1, BC2, BC3, etc. There can be 2 tables or there can be 20 tables imported.
question is how can i append all those tabels into one master? Each table does have column headings but one of them might contain an extra column.
Please let me know if you need more information.