Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2004-10-01 : 04:53:17
|
| Hi,I created a DTS Package to transfer data to MS Excel. In my DTS package, first I create an empty MS Excel and then follow by data transformation. I successfully run the DTS package on a machine with MS Excel installed. When I run the DTS package on other machine withour MS Excel install, I got the following error message:"ActiveX component can't create object "Excel.Application".Is it true that I must install MS Excel on the machine in order for me to create an MS Excel file? Or is there any other solution without install the MS Excel Thank you. |
|
|
Richard Branson
Yak Posting Veteran
84 Posts |
Posted - 2004-10-01 : 05:09:02
|
| As far as I know - uuuhhmm - Yes, you must have have the component before you can start trying to use it.You can't teach an old mouse new clicks. |
 |
|
|
|
|
|
Can't create object "Excel Application"