How to script connection to Excel file in DTS package object


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to script connection to Excel file in DTS package object

  1. #1
    Sergey Guest

    How to script connection to Excel file in DTS package object


    I'm trying to create a DTS package to use in VB6 application. Main objective
    is to import records from Excel file to new table on the SQL server. Both
    Excel and Access using Jet OLE DB provider to connect. What is the difference
    in scripting Excel connection from Access? I can't find the property(ies)
    that stores that information.
    Can anybody help me.
    Thanks in Advance.
    Sergey

  2. #2
    Euan Garden Guest

    Re: How to script connection to Excel file in DTS package object

    If this is SQL 2000 then do Package, SaveAs VB, if its 7.0 then go to the cd
    and get the dtsdemo.exe app and uncompress it, there is a VB app in there
    that scripts packages to VB.

    Now create the package you need and then script it to VB to see the
    connection settings.

    -Euan

    "Sergey" <sergeykaplun@hotmail.com> wrote in message
    news:3bc32249$1@news.devx.com...
    >
    > I'm trying to create a DTS package to use in VB6 application. Main

    objective
    > is to import records from Excel file to new table on the SQL server. Both
    > Excel and Access using Jet OLE DB provider to connect. What is the

    difference
    > in scripting Excel connection from Access? I can't find the property(ies)
    > that stores that information.
    > Can anybody help me.
    > Thanks in Advance.
    > Sergey




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center