Microsoft SQL Server forum - Call DTS package from VBA/Excel?

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Call DTS package from VBA/Excel?

Chad Richardson

2005-04-20, 11:23 am

Can you call a DTS package using VBA (specifically from Excel). I would like
to have a command button to launch a DTS package that extracts data from the
spreadsheet to SQL Server. Today I have to open up Enterprise Manager to do
this.

Any code examples would be great too if this is possible.

Thanks,
Chad

Thomas R. Hummel

2005-04-20, 8:23 pm

Look up "Executing DTS Packages in Visual Basic" in Books online or on
the Microsoft website.

-Tom.

Sponsored Links