S
Sib
Client OS: Win2K
Client Excel Version: 2000
SQL Server: Version 7.0
I'm attempting to populate an Excel 2000 spreadsheet with
the results of an already created DTS package that uses a
SQL script to generate the result set. The DTS package
currently runs successfully, populating the targeted Excel
spreadsheet when launched from Enterprise Manager.
However, I want to execute the DTS from within an Excel
macro. I've coded a macro exactly as stated in KB
article - 306125 "HOW TO: Import Data from Microsoft SQL
Server into Microsoft Excel", and changed the necessary
elements to reference my database and such. This works
beautifully when I tested selecting from a SQL database
table.
Now, I wish to instead have this macro launch/execute the
DTS package instead of doing a .Open "SELECT
<enterstatementshere>" command. Is this possible?
If so, does anyone know how to alter the code in this
article to reference and execute the SQL DTS package
Instead of executing a SQL Select statement? Thanks for
any help.
Sib
Client Excel Version: 2000
SQL Server: Version 7.0
I'm attempting to populate an Excel 2000 spreadsheet with
the results of an already created DTS package that uses a
SQL script to generate the result set. The DTS package
currently runs successfully, populating the targeted Excel
spreadsheet when launched from Enterprise Manager.
However, I want to execute the DTS from within an Excel
macro. I've coded a macro exactly as stated in KB
article - 306125 "HOW TO: Import Data from Microsoft SQL
Server into Microsoft Excel", and changed the necessary
elements to reference my database and such. This works
beautifully when I tested selecting from a SQL database
table.
Now, I wish to instead have this macro launch/execute the
DTS package instead of doing a .Open "SELECT
<enterstatementshere>" command. Is this possible?
If so, does anyone know how to alter the code in this
article to reference and execute the SQL DTS package
Instead of executing a SQL Select statement? Thanks for
any help.
Sib