How to load sql server data into excel

• saidwarak01

  SSCommitted

  Points: 1577

  More actions

  February 24, 2010 at 8:51 am

  #219441

  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...

• Tim Mitchell

  SSCoach

  Points: 15685

  More actions

  February 26, 2010 at 7:50 pm

  #1125901

  This should get you started:

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

  Tim Mitchell
  TimMitchell.net | @tmitch.net | Tyleris.com
  ETL Best Practices

• it-pro

  Grasshopper

  Points: 11

  More actions

  March 24, 2012 at 11:52 am

  #1463928

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