O'Reilly logo

Office and SharePoint 2007 User's Guide: Integrating SharePoint with Excel, Outlook, Access, and Word by Michael P. Antonovich

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

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 ...

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