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