Hi Bill,
Glad to hear that you're interested in trying out executing a Jet stored procedure using MS Query in Excel. Here are the steps to do so:
- Open a new workbook in Excel and go to the Data tab.
- Click on "From Other Sources" and select "From Microsoft Query".
- Choose the database that contains the stored procedure you want to execute.
- In the Query Wizard, select "View data or edit query in Microsoft Query" and click Next.
- In Microsoft Query, go to the "View" menu and select "SQL View".
- In the SQL View, enter the SQL statement for your stored procedure, including any parameters that need to be passed. For example:
Formula:
EXEC my_stored_proc @param1 = 'value1', @param2 = 'value2'
- Click on the "Parameters" button and enter the values for the parameters you included in the SQL statement.
- Click OK and then click "Return Data" to execute the stored procedure and retrieve the results.
That's it! You should now have the results of your stored procedure in Excel. Let me know if you have any questions or if there's anything else I can help with.
Best regards,
[Your Name]