Post reply

Output stored procedure to Excel from Access 2003 adp

  • March 26, 2009 at 7:52 am

    #966670

    This has just worked for me on one of my stored procedures

    DoCmd.OutputTo acOutputStoredProcedure , "EXEC usp_SelectClientByNumber '00010'", acFormatXLS, "c:\test.xls"

  • March 26, 2009 at 10:54 am

    #966861

    Thanks, Chris

    I've got it working now - after a fashion...

    My sp used the parameter to create a temp table, the values of which were returned and output to Excel. This works fine without the parameter and set nocount on - but not with the parameter. I've had to re-jig it.

    Many thanks again for taking the trouble to reply.

    Paul

Viewing 2 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply