From Excel 97, I want to run a SQL Server stored procedure, pass it parameters, and return the results to the spreadsheet. I have an ODBC connection to the SQL Server database if that will help.
Thank you for this response. I'm going to try it later today. Another question: if I want to do the same thing (get data from a SQL Server stored procedure) from Excel, do you have any advice ? Thanks again.
I want to have an Access 97 database call a SQL Server stored procedure, pass it parameters, and retrieve the results of that procedure's final select statement. The SQL Server database is defined in ODBC.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.