Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have a situation where I currently have a huge spreadsheet that is used for tracking 40+ deliverables for projects. The spreadsheet solution is past cumbersome.

I have been thinking about how I can use our SharePoint instance to handle some of these tasks. One option that I have been thinking about was to create a relational database (MSSQL) and then use SharePoint to access and modify the data. I would like to be able to grant users access to specific data elements to allow users to modify the data rather on depending on an administrative resource. This will require some development.

I am relatively new to working with SharePoint so there must be some better ways to implement this functionality rather than the typical list functionality. Right now I am looking for some ideas and this is the best place to find them.

Thank you in advance. Ray

share|improve this question
add comment

1 Answer

You could use SharePoint Business Connectivity Services. That way you could hook up the SQL Server tables to SharePoint lists.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.