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 export stored procedure results to
MS Excel?

Thanks.
 
use Access Data Projects.

double-click on the procedure to execute it; it prompts you for the
parameter inputs.. then it returns the results in datasheet view.

from there; export to Excel, tools, export to excel right?

-Aaron
 
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
Stored Procedure in Access 4
Suppress Stored Procedure message in ADP 3
Using Stored Procedures With Access Data Project 2
What are the steps to fix damaged MDF files in SQL Server? 0
How to call a stored procedure with paramters in SQL Server Express 2008, using code 3
PARAMETERS FOR STORED PROCEDURE (UPDATE, APPEND) 3

Back
Top