Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

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?

share|improve this question

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

share|improve this answer
    
BCS seems not support datasheet view(sharepoint.stackexchange.com/questions/11158/…). What I'm after is the excel-style datasheet view where you can, for example, copy-paste cells to/from Excel multiple rows at a time. –  thomius Mar 1 '12 at 12:32

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

share|improve this answer
1  
BCS doesn't seem to support the datasheet view (see above). –  thomius Mar 1 '12 at 12:36

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.