|
I am using Visual Studios for Applications that shipped with our version of SQL server 2005. I am trying to add a Script task to update an Excel spreadsheet. This is the first time I have done this through code so I have been doing alot of research and it seemed like it was possible calling theMicrosoft.Office.Interop.Excel.Applicationand simply calling the reference in the project. I can not get this to work and continually get the error that it is not defined. when I try to add the reference to the project the COM tab is not even an option just the .NET tab and there does not seem to be any reference for Excel under that. Can this not be done in the version I have? |