TransferSpreadsheet and SP?

B

Bruce Loving

Anyone know if I can export the results of a
stored procedure to Excel?

The online help says Tables or Queries, but I am
in an ADP and want to use a parameter stored
procedure.
 
I

Igor V. Makeev

Hello, Bruce!
You wrote in message on Tue, 11 May 2004 09:25:02 -0400:

BL> Anyone know if I can export the results of a
BL> stored procedure to Excel?

DoCmd.OutputTo acOutputStoredProcedure, "exec dbo.uspName Param1, ...,
ParamN", acFormatXLS, "c:\test.xls"

With best regards, Igor.
ICQ: 111469481
 

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

issue with Form parameters 1
Access can't find stored procedure after scripting on sql server 2
Accessing Stored Procedure via VBA 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Can't create persistent ## tables with ADP call to a stored procedure(!?) 2
I'm John, My first post. 0
transferspreadsheet 2
Report from Stored Proc w/param 4

Top