There are many different way to get data out of SQL Server and into Excel. Here we demonstrate how to do this very easily using QueryCell
1. Make sure you are connected to your SQL Server database.
2. Run your Select Query.
3. Rename the QueryResults Worksheet.
The screenshots demonstrate Excel 2003 but the same process can be used in Excel 2007 and Excel 2010.
After You’ve Got Your Data from SQL Server into Excel
Now that the data you need from SQL Server is in Excel you can use QueryCell to query it using SQL. You can join it to other data in excel for example.
Because the data is in Excel you have access to Excel formulas and functionality.
You can also use QueryCell to run SQL delete statements to remove the data from SQL Server and create Insert statements to insert new or modified data into SQL Server.