create a union query in Access 2010 from 2 tables of linked Excel data

[Jwehrly2000]

I have created an Microsoft Access 2010 database by linking to an Excel spreadsheet. Now the excel spreadsheet contains 2 different worksheets so I had to create two separate tables that hold the information. What I need to do is create a union query so I can combine all the records into one. So for example this is a database of housing records for two different locations and I want to create a query or a report to display all of them together is this possible?

[pbaldy]

Generally:

SELECT Field1, Field2
FROM Table1
UNION ALL
SELECT Field1, Field2
FROM Table2