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

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

-Tom.