ExecuteWithResults

• stephen.bow

  SSC Rookie

  Points: 36

  More actions

  January 19, 2008 at 1:31 am

  #378093

  Hi,

  I need to create an Excel spreadsheet using sp_OACreate and then write the results of a SQL query to the spreadsheet BEFORE I save it. This is because I want to format the data. I would have used "ExecuteWithResults" but see this is redundant. What has replaced it? Can I create an ADODB.Recordset and copy this to Excel? How would you do this?

  Stephen

• Jeff Moden

  SSC Guru

  Points: 1004341

  More actions

  January 19, 2008 at 6:56 am

  #769935

  The following URL has a lot of good information about Excel spreadsheets and ADODB... perhaps it'll have what you're looking for...

  http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/

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