How to create External List using SharePoint Designer 2010



In this article we will be seeing how to create an external list using SharePoint Designer 2010.

Steps Involved:

Open the SharePoint Designer 2010.

sharepoint1.gif

Click on Open Site.

Enter the URL of your SharePoint site.

Click OK.

Your SharePoint site will be opened in the Designer.

In the Navigation, click on Lists and Libraries.

sharepoint2.gif

In the ribbon, click on External List.

sharepoint3.gif

External Content Types Picker wizard will pop up.

sharepoint.gif

Select the external content type and click OK (You can check the following link for creating the external content type).

Create External List wizard will pop up.

sharepoint5.gif

Enter the Name and Description for the list.

Go to the SharePoint Site.

External List is created successfully.

sharepoint6.gif

Click on External List, you can see the items displayed.

sharepoint7.gif