How to load sql server data into excel

  • Hi Everyone,

    I have an urgent need to load sql server data into preformatted excel sheet. The excel sheet is prefilled with some excel sheet information in starting 4 rows and there are column headings in the 5th row. Now, I need to populate the data for the corresponding columns in the 5th row from sql server table.

    Please find attached template of the excel sheet.

    Please let me know if anybody has any solution and its very urgent task.

    Thanks in advance...

  • This should get you started:

    http://www.mssqltips.com/tip.asp?tip=1393

    Tim Mitchell, Microsoft Data Platform MVP
    Data Warehouse and ETL Consultant
    TimMitchell.net | @Tim_Mitchell | Tyleris.com
    ETL Best Practices

  • attached Excel Sheet will help to solve your Problem ... created with Excel 2003, tested with MSSQL 2008

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply