>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 ($).