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 |
|
reen15
Starting Member
3 Posts |
 Posted - 2006-02-13 : 16:04:24
|
| I'm trying to create an ActiveX script to alter an Excel file and the task keeps bombing at CreateObject("Excel.Application"). Does Excel need to be installed on the server for this CreateObject to work? Excel is not installed on the server this DTS resides on.Thanks in advance...Erin |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-13 : 19:24:42
|
| no, once you have your connection setup correctly, reading it would not be a problem, see www.connectionstrings.com |
 |
|
|
kingroon
Starting Member
29 Posts |
Posted - 2006-02-13 : 19:36:28
|
| Err.. Hi Erin, I think you do need Excel installed on the server..I had a similar issue when downloading a remote file and opening it using the CreateObject("Excel.Application") method. My solution? I downloaded a text/csv version instead..Chaotician Man,Slice the lines of virgin pathways.Harmony Hero. |
|
|
|
speedingwolf
Starting Member
1 Post |
Posted - 2006-02-13 : 19:46:43
|
| Is it okay to install Excel on SQL in production? I am having the same issue but not sure if it has any effect to SQL server. Thanks |
|
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-02-13 : 19:51:35
|
| >>Err.. Hi Erin, ???Well, i havent test it as such, but we do read and export to excell from the remote server, which hasnt got excell installed. Thats why i said no. Am also looking at linux servers, that can also export via php to excell files.Well its best to test and see in this particular case. |
|
|
|
Merkin
Funky Drop Bear Fearing SQL Dude!
4970 Posts |
Posted - 2006-02-13 : 23:38:51
|
quote:
Originally posted by afrika
no, once you have your connection setup correctly, reading it would not be a problem, see www.connectionstrings.com
Wow, you couldn't be more wrong  Damian"A foolish consistency is the hobgoblin of little minds." - Emerson |
|
|
|
|
|
|
|
|
ActiveX - Excel help