I'm trying to figure out the syntax of using the sp_oamethod SQL 7.0 ole extended stored procedure to execute the 'Add-Ins' in excel to add in the 'Analysis Tool Pak - VB'. I know that I can do this in an excel macro by executing:

AddIns("Analysis ToolPak - VBA&#34.Installed = True

OR

AddIns.Add("C:Program FilesMicrosoft Office 2000officeLibraryAnalysisAnalys32.xll&#34.Installed = True

But, I'm not sure as to how to use them from SQL 7.0. Any help on the syntax of the sp_oamethod would be helpful.

Thanks
GG