DTS query with vb to excel

Hi,
does anyone have an example for doing a query in dts via vb an exporting it
to excel
ths and reg
bxandiUse the DTS Wizard to create a package then save the backage as a VB
file. You can then modify the VB code to your requirements.
An alternative option is to use Excel's QueryTables.Add method to
import the data with no DTS required.
David Portas
SQL Server MVP
--