Post reply

can and how do you run a stored procedure from access

  • January 24, 2006 at 2:19 pm

    #166723

    can and how do you run a stored procedure from access?

     

    tanx!

  • January 24, 2006 at 4:27 pm

    #616783

    You may use VBA with ADO (in a module) and create connection object to your SQL Server database and then use CommandType = Text for your Command object

    Regards,Yelena Varsha

  • January 24, 2006 at 5:29 pm

    #616793

    thanks!!

  • January 25, 2006 at 10:18 am

    #616970

    There is another way do it without using VBA.  You can create a PASS-Through query and copy the stored procedure including all parameters over (exec stored procedure 'para1','para2'....). 

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

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