W
Webtechie
Hello,
I needed to figure out how to have a spreadsheet perform a lot of data
processing and then send the data to Sybase. It occurred to me to let
Microsot SQL Server DTS bring the data from Excel and then process the data.
I found a link on the web that details how to have VB execute a DTS package.
http://www.sqldts.com/default.aspx?208
I can create an Excel spreadsheet, create a button, attach the button to a
macro and the macro will call DTS. Works great.
Question:
Since I am a developer with SQL Server loaded as well as Microsoft Excel, I
only had to select References and check the "Microsoft DTSPackage Object
Library".
When I deploy this spreadsheet to the clients, they won't have SQL Server
loaded. They might have just the Client connectivity loaded. How do I
check for the instance of the object library? If it is not present, how do
I load it (from somewhere) to insure that Excel can call DTS? How do you
check for the existence and/or load it via code.
I apologize if I am in the wrong forum for this question.
Thanks.
Tony
I needed to figure out how to have a spreadsheet perform a lot of data
processing and then send the data to Sybase. It occurred to me to let
Microsot SQL Server DTS bring the data from Excel and then process the data.
I found a link on the web that details how to have VB execute a DTS package.
http://www.sqldts.com/default.aspx?208
I can create an Excel spreadsheet, create a button, attach the button to a
macro and the macro will call DTS. Works great.
Question:
Since I am a developer with SQL Server loaded as well as Microsoft Excel, I
only had to select References and check the "Microsoft DTSPackage Object
Library".
When I deploy this spreadsheet to the clients, they won't have SQL Server
loaded. They might have just the Client connectivity loaded. How do I
check for the instance of the object library? If it is not present, how do
I load it (from somewhere) to insure that Excel can call DTS? How do you
check for the existence and/or load it via code.
I apologize if I am in the wrong forum for this question.
Thanks.
Tony