Sib
2003-08-27 19:57:44 UTC
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 the DTS
package I have instead of doing a .Open "SELECT
<enterstatementshere>" command as displayed in the KB
article. Is this possible?
If so, how do I reference the DTS package within the Excel
macro? 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 the DTS
package I have instead of doing a .Open "SELECT
<enterstatementshere>" command as displayed in the KB
article. Is this possible?
If so, how do I reference the DTS package within the Excel
macro? Thanks for any help.
Sib