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


3.  Enter server Name & authentication mechanism


4.  Select database & then select the table


5.  Click finish

6. click ok on excel popup.

below is the result.


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



Sukhija Vikas

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s