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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I export stored procedure results to excel? 1
Call stored procedure in SSMS from Access 2016 doesn't work. 0
Need help on Stored Procedure 2
What are the steps to fix damaged MDF files in SQL Server? 0
Cant call stored procedure which uses table variables? 3
Application.ExportXML 4
Passing dates to Sql Server 2005 stored procedure 1
How to Export Gmail Emails to PST Format? 4

Back
Top