Excel -> Macro -> DTS ??

J

joaovtt

Hi All,

I'm developing an ETL process where I need to extract data from several
excel workbooks. My question is the follow: Is there a way to call a DTS
package from a Excel macro?

Any help will be welcome. :)

Thanks a lot!
Joao Vitor.
 
K

keepITcool

google on

Executing DTS Packages in Visual Basic
you should find several articles on MSDN

--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


joaovtt wrote :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Push data from Excel to SQL Server 2
Deploy "Microsoft DTSPackage Object Library"?! 0
How to convert text files into excel 3
How to call Excel add-in macro from a button… 1
can't close files opened in an excel application?? 3
Macro to hide empty worksheets 6
Macros to extract data frommultiple workbooks to a master workbook 0
Determine name of macro contained in each excel file in a folder 9

Top