Unanswered: Executing Stored Procedures From Excel
I have read a few different techniques on executing stored procedures from Excel but I am not sure what is the best technique. It seems link using and ADO connection is favored by many, If so what is the best way to learn this technique or does any one have any syntax examples? MSDN also references using the SQLRequest method but this requires an additional snap-in and seems like older technology. For starters I am not concerned with passing parameters but I do want that ability in the future.