External Data from Stored Procedure with parameters

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

How do I source external data from a SQL Server stored Procedure with
parameters..

A stored procedure *without* parameters is not problem --> (get external
data - new db query - enter "exec sp_MySpName" into MS-Query)


However, with adding parameters, when the user selects "Refresh Data!" I
would like the user to be prompted to enter the values as per the stored
procedure parameters..

e.g. exec sp_MySpName @StartDate = [prompt user], @EndDate = [prompt user]

Is this possible?


.