paul.knibbs (1/9/2013)
Couldn't you work it the other way round and use a connection to SQL from the Excel spreadsheet to populate its columns? Difficult to say how viable this is in your particular environment, but I know Excel is certainly capable of getting data from a SQL server source like this.
Paul, that wouldn't be feasible in our environment since we recalculate the financial values each time data is saved.
lptech (1/9/2013)
You could do it an extended stored procedure (xp).http://msdn.microsoft.com/en-us/library/aa214418(v=sql.80).aspx
lptech, this actually does look promising, but Excel isn't installed on the SQL 2000 Server I'm using so I don't have access to the Interops to build the DLL I'd need to calculate the financial values. So I'm running into a roadblock not with SQL but rather with our server configuration. But this might be an option for another project I'm working on, so thanks 🙂