How can I convert MS SQL database into Excel file

Discussion in 'Databases' started by er_Saurabhgupta1986, Jul 28, 2007.

0
  1. #1
    Hi
    I wanted to get MSSQL database data to be converted into an Excel file.

    Can anyone help me
     
    er_Saurabhgupta1986, Jul 28, 2007 IP
  2. mamina

    mamina Active Member

    Messages:
    316
    Likes Received:
    4
    Best Answers:
    0
    Trophy Points:
    60
    #2
    I would like to know as well...

    One way that I DO know...

    Load the database into a web site... doesn't matter which just one that has Control Panel.

    When you EXECUTE the SQL you can then DUMP it out in CSV format allowing you to open it in Excel.

    There has to be an easier way though.
     
    mamina, Jul 28, 2007 IP
  3. no-username

    no-username Banned

    Messages:
    10
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #3
    Do you know about importing and exporting option in MS SQL, by exporting you can Convert whole data into Excel Sheet. And by Importing you can import data into MS SQL.
     
    no-username, Jul 29, 2007 IP