To Use sp_OACreate, Do Office Apps Have to be Installed on Server? 1

[JohnBates]

hi everyone,

This is SQL Server 2005.

I want to output an Excel worksheet, so I will need to use the sp_OACreate, sp_OAMethod, sp_OADestroy extended stored procedures.

But Excel is not installed on the server. Will this cause any problems?

Thanks, John

 

[AlexCuse]

Only one way to find out ;-)

I wonder if you'd be better off doing this through DTS though? I usually put a "template" excel file somewhere, and copy it with the proper name (to be used as a destination), then fill it with data. This may get you around the requirement of having excel on your server (because after all, you don't want to run two high-powered database servers on one computer).

Hope this helps,

Alex

[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page

 

[JohnBates]

Thanks Alex.

I forgot to mention this is the Express edition, but yes I would normally opt for SSIS.

I'm really asking for of our developers, new to SQL Server. I'll suggest he try it and see if Excel is required.

Thanks, John

 

[AlexCuse]

For 2005, CLR might be another option (I think this is available in Express).

From there, you might be able to make use of something like this:

http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

To create your spreadsheets.

Can you tell that I hate any dependency on Office? ;-)


[small]----signature below----[/small]
Majority rule don't work in mental institutions

My Crummy Web Page