In excel: how-to join external tables without importing to excel

Hi, 

I have to analyse (in many ways) 2 external tables (accdb) that are needed to be joined first. Unfortunately they are so long that it's not an option to import them in the excel file. 

As an alternative I could join the 2 tables within the accdb but still, the outcome would be to be big to be imported to excel and then being analysed there. 

Could you anyone give me a clue on which direction I need to look for a solution? I really want to do the analysis in excel because of the many ways to create nice management friendly charts there.

Thanks for helping out!