Microsoft® Access® 2010 Inside Out

Importing and Linking SharePoint Data

In Microsoft SharePoint terminology, a table is referred to as a list that stores information about a single subject. In a list you have columns (fields) that contain the different kinds of information about the subject. Similar to how you work in Access 2010, you can work with lists in different views for adding and editing records. In order to import or link to a list from a SharePoint site into an Access database, you need to have appropriate permissions to the SharePoint site. Contact your SharePoint administrator to give you permissions if you are having trouble accessing the SharePoint list.

Importing a List from a SharePoint Site

Importing a list from a Microsoft SharePoint site works in much the same ...