Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word

6.2. Linking SharePoint Lists to Access

In the examples discussed in the previous section, you imported a copy of the SharePoint list data into an Access table. Before continuing with some other ways to work with SharePoint data from Access, let's see how linking to the SharePoint lists differs from simply copying the data into an Access table.

Because you have already seen how to begin a transfer of a list from SharePoint to Access in the previous section, let's pick up the transfer at the point where you have to decide whether to link to SharePoint or simply copy the data. Figures 6-2 and 6-12 earlier illustrate this point in the process beginning with SharePoint or Access, respectively. However, this time, rather than copying the list data ...