Mahesh Chand
How can you get data from a database in an Excel sheet?
By Mahesh Chand in COM Interop on May 25 2012
  • Mihir
    Jul, 2012 17

    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.

    • 1


Most Popular Job Functions


MOST LIKED QUESTIONS