Linking Two Tables with Identical Headers

[Mbessette]

Hi,

I have a massive amount of excel data (exceeded the # of rows excel can hold in 1 sheet), so I added a second sheet. Both sheets are in the DB as linked tables but how do I link them so that when I run a query I will get results from both tables.

The information in both tables contains medical procedures by date (physician, location, products used, etc). Header fields are identical. Point of the query is to identify products used over a 12m period of time and tie it to a physician.

Thank you,
Mike

[Micron]

You could try a UNION query.
FWIW, most of the time, Excel spreadsheets make for poor Access tables because they're not properly normalized. Your best solution is likely to create properly normalized db tables and use queries to split the sheet data into those tables. If you have a pic of your db relationships we might be able to comment on that.