2

We have few "Database Connections" created in SP Designer 2010 and I used the "Data view" web part to display the database connections' data.

Is it possible to export this data to an excel?

4

Unfortunately, it's not possible!

The Export to Excel option is not available in the External List in SharePoint 2010. Check the full limitations list at my article External List limitations in SharePoint 2010/2013

Note: The Export to Excel option is available for External List in SharePoint 2013.


[Update]

Unfortunately, there is no OOTB option to export Data View with an external database connection in SharePoint.

But you can use Jquery as a workaround to achieve that as I mentioned at Export Data View to excel in SharePoint

enter image description here

  • Are you talking about BCS or Database connections in SP2013? In SP2013, For Database Connections, I dont see an option to "Export to Excel". – George Sep 8 '17 at 14:30
  • I talk about the Export to Excel option in the external list that created from external content type in sharepoint designer, and you asked about it in sp 2010 that is not available, but it available in sp 2013 – Mohamed El-Qassas MVP Sep 8 '17 at 14:33
  • My query is not related to "External content Types" but it is regarding "Datasources". I have created few "Database connections" and want that data to be exportable in Sharepoint – George Sep 8 '17 at 14:47
  • @George Sorry for that I confused with the data connection and BCS let me update my answer with the detail steps that related to your question – Mohamed El-Qassas MVP Sep 8 '17 at 15:38
  • 1
    In SP2010,when i right click on the webpart and select properties, i don't see the properties as displayed in ur image,rather i get only Tag properties. I can see the "SharePoint Toolbar" in the ribbon, (Design --> Options)however it is grayed out. – George Sep 11 '17 at 15:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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