Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Need Excel but Excel Not Installed...
Message
From
03/11/2005 14:32:10
 
 
To
03/11/2005 14:17:21
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Miscellaneous
Thread ID:
01065132
Message ID:
01065149
Views:
17
>Excel is not installed on server SQL. I use ActiveX task in local package to create (in VB Script code) many parametrized Excel files. The access to network is denied by SQL Server account. Then I wonder if it exists another way to access to Excel.. like COM or DCOM or another technology like that?

I think you have some confusion here.

Do you mean Excel is not installed in the same box as SQL Server?

When you use ActiveX you are using COM (VBScript of VFP does not matter). The way you are accessing Excel is through COM. In order to do that, basically taking a reference to Excel with something like:
oExcel = CreateObject("Excel.Application")
requires MS Excel to be installed.

There are way to create XLS files without Excel installed but they are not easy and sometimes expensive ($).


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform