Using External Lists In Sharepoint. By using an External List you can display the contents of a table from SQL Azure in SharePoint. As a workaround you can try to export the external list in SQL server to Access first and then export it to SharePoint.
As a workaround you can try to export the external list in SQL server to Access first and then export it to SharePoint. On the Your Apps page in the search dialog enter External List and search. Click the Create button.
On the Server ribbon click Edit List.
The data source for an external list is called an External content type. In order to implement the integration we have to ensure that the two pieces given below are in place. We cant compare external lists with standard lists where data is stored inside of SharePoint. Click the Create button.