How can i export data in execel file in predefined excel format...

• Jeff Moden

  SSC Guru

  Points: 1004664

  More actions

  January 4, 2008 at 9:37 pm

  #765041

  3 pages starting at...

  http://www.sql-server-helper.com/tips/read-import-excel-file-p01.aspx

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)
  

• Lester Policarpio

  SSCertifiable

  Points: 7109

  More actions

  January 6, 2008 at 8:53 pm

  #765206

  You can also use sp_makewebtask

  exec sp_makewebtask @outputfile = 'C:\mypath\lester.xls',

  @query = 'select * from table',

  @colheaders =1,

  @FixedFont=0,

  @resultstitle= 'My Title',--Name of the report etc

  @dbname = 'db_name' --'database_name'

  Although i think this will be disregarded in MSSQL 2008 but anyways if your not using 08 as of now you can use this. Just my 2 cents..

  "-=Still Learning=-"

  Lester Policarpio