Connecting SQL Tables and data in Excel spreadsheets

SQL server is a powerful database platform, this means that it can also be complex to understand and work with. However the major users of the data in the database are still a non-technical business user. A key problem that most business users face when it comes to working with SQL Server is the dependency on an IT professional to query and return the data in a CSV format or Excel sheet. With the ability of MS Excel to be able to connect to SQL Server via the ODBC Drivers allows users to work with SQL tables within the familiar Excel User interface. This approach allows users to be productive with SQL Server without having to know Transact SQL. The feature set provided with MS Excel and newer versions of SQL allow business users to do much more than just query the database. These include the ability to query and view data in pivot format for large data sets using power pivot. Perform ad hoc calculations to underlying data and create models that are specific to their business case using the powerful DAX language. Embedding reports in SharePoint services using PowerPivot.
Working with Excel is one of the most powerful ways that end users can work with MS SQL Server to deliver results faster and improve productivity.

[HighSoftware]

This is a great way to use Excel as a business analytic tool for reporting applications running on Microsoft SQL Server

[bondniko]

You can also tell people about the possibility to modify the table's data source and build a multitable query to better suit their needs

[mz_ppp]

how to find the server name from my MySQl workbench?

[baileyyork]

How do you find out what your SQL server name is?

[Shawn-dtfl]

Thank You please continue to share that was very informative.

[NickSmith-hvzi]

If data is saved in the excel, will it reflect in the SQL? or this is a one way only?  thanks

[rugwizainnocent]

hello Dear, I want to select data from view, not a table. and a view is not selectable

[dz-zsvj]

hi I have export an excel csv file and I want to add a column using
conditional fractionation transformer in ssis how i do that ?

[sajidsidi]

Can we fetch data using ready made query which contains multiple joins ?

[Khusbu]

Hi, one question if data are getting the update in SQL then will data update in excel also?

[jamespruett]

SELECT * from blah where date between a and b; How can I feed "a", "b" into it?

[JayanthKurup]

You can't move data from Excel to SQL