Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference a SQL DTS package in Excel Macro
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SSIS package converting int's to text in Excel | Excel Discussion (Misc queries) | |||
PACKAGE & DEPLOYMENT WIZARD | Excel Discussion (Misc queries) | |||
excel chart rendering problem when using apache java Poi package. | Excel Discussion (Misc queries) | |||
Excel 2000 post-Service Pack 3 hotfix package Q841881 | Excel Discussion (Misc queries) | |||
An additional charts package? | Excel Discussion (Misc queries) |