How do I export stored procedure results to excel?

  • Thread starter Thread starter Sunny
  • Start date Start date
S

Sunny

Hi,

I have written stored procedure, which accepts input and produces results
set depends on input parameter. How can I pass parameters to stored
procedure from VBA and exports results to MS Excel?

Thanks.
 
One way to pass parameters is to use a pass-through query object, and
rewrite the SQL of that query each time. You can then export that query to
Excel using TransferSpreadsheet.
 
Back
Top