I have seveal spread sheets loaded on MOSS 2007 (we have Excel Services). We host our SP on Sql Server 2008 R2 64 Bit on a Windows 2008 64bit server. I want to be able to write a query on that SQL Server database that can somehow access excel
data directly from SP and cmpare that to data in SQL. I have been able to create a linked server (using 32 bit sql server) but have only been able to link files directly off the server and NOT from MOSS.
So the Crux of the matter: Is there a way of making some love connection that would allow me to get data directly from my excel spreadsheet that resides ON SHAREPOINT, via my Sql Server?
View Complete Post