Connect to the database We tried this using MS-SQL 2000 Server for the database and Excel from MS Office XP. To query the database, start Excel, go to the Tools menu and click on Add-Ins.

Excel Power Query makes importing, cleaning, and analyzing even the most enormous datasets accessible. Here are some reasons why you should be using Power Query.

This SQL feature allows you to query within a result set, creatively limit your result set, or correlate your results with an otherwise unrelated query in a single call to the database.