Hi, I want the data in excel, pulled from SQL server stored procedure. The SQL SP has the parameters.
when we open/refresh the excel it should prompt the user to enter the parameters (dynamically), and depending on the parameters the relavent data should be populated in excel.
Appreciate your help
seyyadri
Last Activity: Sep 15 '08, 06:25 PM
Joined: Sep 9 '08
Location:
-
seyyadri started a topic How to Pass Parameters from Excel to SQL Server Stored Procedure and get the datain AccessHow to Pass Parameters from Excel to SQL Server Stored Procedure and get the data
-
Thank you very much, I wil try and let you know... -
Sorry for confusing.
I want the data in excel, pulled from SQL server stored procedure. The SQL SP has the parameters.
when I open/refresh the excel it should prompt the user to enter the parameters (dynamically), and depending on the parameters the relavent data should be populated in excel. thank you...Leave a comment:
-
How to Pass Parameters from SQL Server Stored Procedure to Excel
Hi,
I am new to Excel programming, can you please explain how can I pass the parameters of SQL SP to excel.
If I am not having any parameters I am using EXEC <SP Name> using new database query in Excel - it works.
Now I am having 2 parameters, how can I do that?
I am trying to use: EXEC <SP name> @param1, @param2, but it is giving error.
appreciate your help
No activity results to display
Leave a comment: