TransferSpreadsheet and SP?

  • Thread starter Thread starter Bruce Loving
  • Start date Start date
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.
 
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
 
Back
Top