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