Trouble in Using Stored Procedure in Excel

• Stylez

  SSCrazy

  Points: 2195

  More actions

  November 25, 2014 at 4:33 pm

  #397690

  Good Evening Guys,

  I would like to kindly ask if i am missing a step in retrieving Data to excel using My Created Stored Procedure from SQL Server 2008

  here are the steps that i have currently done so far

  Created A Stored Procedure To Extract Data

  SP_AuditTrailReport(@StartTime,@EndTime)

  I go To excel (By The Way i am using Excel 2013)

  Go To Data Tab

  From The Other Sources Ribbon i selected "FROM SQL SERVER"

  i put in my credentials and everything connection was established

  When i go to the Connection Properties Window Under the Definition Tab i filled in the Command Text Section as follows exec sp_AuditTrailReport @StartTime,@Endtime

  Selected Command Type as SQL

  And then pressed OK

  i am just wondering why i cannot retrieve the 2 dynamic parameters from SQL to be used as an input in my Datasheet in excel. any help from you guys is very much appreciated

• dbalmf

  SSCrazy

  Points: 2063

  More actions

  November 27, 2014 at 6:30 pm

  #1761357

  Hi There,

  Have a look at this web page, it should give you what you need. I use this method and it works fine.

  http://codebyjoshua.blogspot.com.au/2012/01/get-data-from-sql-server-stored.html

  Ta

  David

  ============================================================
  David

  http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]