sql

• pawandeepsingh07

  Newbie

  Points: 1

  More actions

  March 6, 2009 at 11:21 am

  #206749

  How to import data from sql server 2000 to excel sheet through a stored procedure.

• vijaysingh

  SSC Eights!

  Points: 982

  More actions

  March 6, 2009 at 9:41 pm

  #955397

  Hi,

  Try this.

  INSERT INTO OPENROWSET('Microsoft.Jet.OLEDB.4.0',

  'Excel 8.0;Database=C:\testing.xls;',

  'SELECT Name, Date FROM [Sheet1$]')

  SELECT [Name], GETDATE() FROM msdb.dbo.sysjobs

  GO

  Try these Links

  http://www.sqlservercentral.com/Forums/Topic334873-338-335131

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

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

  Regards,

  Vijay Singh.C

• Jeff Moden

  SSC Guru

  Points: 1004361

  More actions

  March 6, 2009 at 10:06 pm

  #955402

  It would likely be better if you wrote the spreadsheet to pull from a view or proc using the "external data" features.

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