Microsoft Office Excel - Connect To SQL Server
We can populate the Microsoft SQL Server database table data to Excel Worksheet. Today we discuss about how to connect to Microsoft Office Excel sheet to SQL Server.
1. Open Microsoft Office Excel File
2. Go to Data tab, From Other Sources list => select From SQL Server, it opens SQL Server connection window as shown below.
3. Enter the connection string details and click on Next > button, it opens database window as shown below.
4. Select required database from the database list and select table; click Next > button, it opens the window as shown below.
5. Click Finish button, it opens window as below.
6. Select excel worksheet details and click on OK. It opens below window.
7. Enter SQL server login details again and click OK. It shows the result as shown below.
This way you can connect to any SQL Server database object means you can call table, view to populate the data.
We can connect to any other source like to Analysis Server, to XML data source, to Access database....etc from Microsoft Office Excel.
Recently Microsoft released its new Office version Microsoft Office 2013. Purchase this new Microsoft Office version with great discounts by using Microsoft Office 2013 Promo Code.
