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

[beispielwiese]

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!

[dufoq3 · Accepted solution]

Hi @beispielwiese,

• import both tables into PowerQuery
• do necessary transformations
• load both table into PowerPivot
• create relationship in PowerPivot
• create measujes you want
• create charts or tables based od PowerPivot Source