O'Reilly logo

Microsoft® SharePoint® Designer 2010 Unleashed by Kathy Hughes

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Creating an Office Item External List

Creating an Office item type External List is very similar to creating any other External List. Use the following steps to create an Office item External List.

1. Select External Content Types within SharePoint Designer and click the new External Content Type button.

2. Name your external content type Customers.

3. Select the drop-down next to Office Item Type and choose Contact. Notice in this drop-down that other choices are Appointment, Task, and Post.

4. Click External System and then in the new window select Add Connection and choose SQL Server as the data source type.

5. Specify your SQL Server and the database name of AdventureWorksLT; name the connection AdventureWorksLT. For this example you continue ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required