Combining 2 or more Tables

[thevolk]

Hi All,
Basically what I have is an excel sheet with 6 workbooks, each have the same fields, but I had to separate them due to the size. I'm importing these workbooks into Access as tables, but I want to merge all the tables into one. Is this possible?

Thanks!

 

[MyBoo]

Import them into Access and then merge them into one table using an Append Query. Being that they all have the same fields, this should be very basic and very easy.