[dba-SQLServer]Exporting SPROC with Parameters to Excel

David Emerson davide at dalyn.co.nz
Thu Apr 3 18:15:57 CST 2003


I am able to use the following line to export the result of a sproc to excel -

     DoCmd.OutputTo acOutputStoredProcedure, "spBookingExport", 
acFormatXLS, strFullName

However, can I do it if the sproc has parameters and I don't want the user 
to have to enter in the values as they are already on the form that calls 
the sproc?

Regards

David Emerson
DALYN Software Ltd
25b Cunliffe St, Johnsonville
Wellington, New Zealand
Ph/Fax (877) 456-1205 



More information about the dba-SQLServer mailing list