Trying to run a SQL Server Stored Procedure from Excel’s “Get External Data” facility. I can successfully read a Table from the database but my attempts to return the results from a store procedure have failed. A PDF file is attached that show the steps I have taken so far. The problem may be the syntax I am using to call the stored procedure from the connections properties dialog. I have tried several variations but no luck so far.
Any help or advice is appreciated.