Excel connection in DTS package

• Joseph Victor

  Grasshopper

  Points: 17

  More actions

  May 20, 2004 at 10:30 am

  #60103

  Hi,

  Is there is any other way to open a connection to an Excel application using ActiveX script in DTS other than

  set App=CreateObject("Excel.Application")

  Can we use the Jet Connection which the DTS package uses?.

  Thanks

• philcart

  SSC-Forever

  Points: 47796

  More actions

  May 20, 2004 at 8:43 pm

  #507209

  If you are using the Excel Application object to do things like formatting, etc... then no. Jet doesn't know about Excel properties.

  --------------------
  Colt 45 - the original point and click interface