I have an Access 2003 database with 5 tables. The structure of each table is identical but the content is different. I would like to combine the data into one new table. How do I do this?
I don't think I want to employ a query approach. I literally want to combine them all.