Technologies - SQL Server 2008 R2, MOSS2007, and Office 2007
I have a set of SharePoint lists which I would like to expose to a variety of reporting technologies (SSAS, SSRS, etc).
I am constrained with out of the box functionality, so custom solutions or third party options is not a luxury I have. SO, I am thinking of...
Data entered into a sharepoint list
Using MS Access "link to data source by creating a linked table" option in Access to my Sharepoint lists
Then creating a linked server in SQL Server to the Access database.
Is this at all possible?
View Complete Post