Executing Stored Procedure

• Edward S Randazzo

  SSC Rookie

  Points: 37

  More actions

  July 31, 2006 at 7:49 am

  #62566

  Hi,

      Is there a way to execute a VB6 exectable from a SQL Server 2000 Stored Procedure.  I am developing a Visual Basic project that captures data from several tables then exports that data to Excel. 

  Thanks

  Erandazz

   

• Vasc

  SSCarpal Tunnel

  Points: 4643

  More actions

  July 31, 2006 at 9:53 am

  #652412

  Take a look at

  xp_cmdshell / Data Transformation Services

  ---

  Kindest Regards,

  Vasc