How to script connection to Excel file in DTS package object

[Sergey]

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

[Euan Garden]

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