Thursday, September 5, 2013

Connect Excel to SQL

Hi All,

Today I am sharing a method that We can use --> connect Excel to SQl server database.

Steps to follow:-

1. open excel
2. From data Tab select -->From other Sources -->From SQL server
exl1

3.  Enter server Name & authentication mechanism

exl2

4.  Select database & then select the table

exl3

5.  Click finish
6. click OK on excel popup.

below is the result.

exl4

Not only that you can go back to excel dataconnection & modify the select query as well

exl5

regards

Sukhija Vikas

No comments:

Post a Comment