Microsoft Office Tutorials and References
In Depth Information
Using a SharePoint List As a Data Source
After you create the SharePoint list from Access, you can add and modify
data just as you would with any other local or linked table. The changes you
make will be accessible to anyone else who has access to the SharePoint site.
To make changes in the design of the SharePoint list, right-click the table name
in the Navigation Pane and choose More Options ➪ Modify Columns and
Settings from the contextual menu. The Customize page on the SharePoint site
loads in a new browser window, in which you can use the SharePoint tools
to modify the list’s structure.
Linking to an existing SharePoint list
If your SharePoint site already contains lists (usually created by a SharePoint
administrator or developer) that you want to get information from and make
changes in, you want to link to those SharePoint lists. To link to an existing
SharePoint list, follow these steps:
1. Click the SharePoint Lists button in the Tables group on the Create tab
on the Ribbon (refer to Figure 3-1, earlier in this chapter).
2. Choose Existing SharePoint List from the drop-down menu.
The Get External Data – SharePoint Site Wizard loads.
3. Enter or choose a SharePoint site at the top of the first screen.
As with linking to other external data sources, you’re prompted to
import the data into your database or link to the data source in a linked
table. If you import the data, you get a snapshot of the list at the time
you perform the import, and any changes you make won’t be reflected
on the SharePoint server. If you choose to link to the data source, you
see the data that other users enter and modify — and they see your
For further assistance on when to import data and when to link to data
in another data source, see Book II, Chapter 4.
4. Click Next to display the list of SharePoint lists to link to (as shown in
Figure 3-4) or import.
5. Click the check box to the left of each list that you want to link to and
then click OK in the bottom-right corner of the screen.
The SharePoint lists that you chose to link to appear in the Access
Navigation Pane as linked tables, just as they appear in Figure 3-3, earlier
in this chapter. If you chose to import the lists, the data is stored in local
Access tables, and the standard Access table icon (without an arrow)
appears next to the table names.