Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesCan 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
Post Follow-up to this messageLook up "Executing DTS Packages in Visual Basic" in Books online or on the Microsoft website. -Tom.
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread