I would like to manipulate an sql table via web interface in sharepoint the same way I use datasheet view for SharePoint lists. I would be interested in any kind of a non-commercial solution. Or would the only possiblity be to open the sql table in a client (ms office) app?

2 Answers 2


You can do it via BCS. Check this out : http://blog.arjanfraaij.com/2011/07/sharepoint-2010-using-bcs-with-sql.html


Very Simple soltion connect the sql table to sharepoint using BCS you can do this easily in sharepoint designer. your interface will then be the same as a list

  • 1
    BCS doesn't seem to support the datasheet view (see above).
    – thomius
    Commented Mar 1, 2012 at 12:36

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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