How can you get data from a database in an Excel sheet?
Mahesh Chand
In Excel sheet we have Data tab is there. In that we can have "From Other Source" as option in the ribbon. Click that one. Select sql server and connect. Give database details and select the table and columns what ever you want.