How to left join Excel table to a table in SQL Server data base

[letsplaay]

Hello,

I have a table (tbl1) in Excel file with about 70k rows. There is another table (tbl2) on the SQL Server with millions of rows that I need to left join to the table in my Excel file on tbl1.[Member Number] = tbl2.[memid]

What query should I use to do it without having to import the whole tbl2 from SQL Server?

Thank you!

 

[ImkeF]

This can be done with Power Query but for Performance aspects you probably want to make sure that the filtering is done at the server. Have a look at my latest blogpost on how to achieve this:

Filter SQL-server queries with Excel-tables: Query folding limitations and bug workaround – The BIccountant