drew.georgopulos (5/9/2013)
Himy instinct is Access would be best, but iirc, you can create parametrized stored procedures in SSMS & invoke them from Excel...i guess it depends on how robust the front end must be and how much you want to stick with Excel, but its viable.
best
drew
You can definitely call parameterized stored procedures from Excel, with a few caveats. 1. You must use an ODBC connection. 2. The only way I've found to set up the query in Excel is to add a simple table query, then modify the command text on the connection to the stored procedure.
There are also ways to call stored procedures from Excel VBA, but I don't do that often so I don't remember offhand how.