I have a database training yearly training. The excel sheets are divided by the year. I want to add them to access so I can do queries over multiple years. Rather than place the data in one big table, I have created tables for each year. This way, I can update individual tables when I receive data about a specific year; rather than having to update the entire table of all the years each time.
I am trying to build a query that then pulls the data from all the tables into one source. I tried to create a Union query, but was unsuccessful.
Would an append query work?