I have tried to get an answer to this on verious forums, but none are really giving me the answer.
Step 1: Microsoft Excel
Cell A1 = Orange
Cell B2 = Monkey
The Excel file also contains a pivot table.
Step 2: I want to use the values in A1 and B1 as parameters for a SQL Server 2000 Stored Procedure.
Thus, I need to know what steps must I take, to link to the Stored Procedure from excel, where the results are returned to the Pivot table.
Example of Stored procedure is shown below.....
How do i call the stored procedure?
How do i ensure is uses the paramters set?
How do i ensure that it returns the results to the pivot table?
Server = Busobjects
Database = Cap_plan
Create Proc sp_flickimp
Select Location, sum(total_number)
From [Busobjects].Cap_plan.dbo.tbl_information as tbl
Where tbl.colour = @colour --this would be orange
and tbl.type = @type --this would be monkey
Group by Location