O'Reilly logo

Integrating Microsoft by Alison Balter

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

Section 6. Linking to and Importing from SharePoint Lists

You can easily create an Access database from existing SharePoint lists. The process is quite simple:

  1. Open the database within which you want to place the new tables.
  2. Click to select the External Data tab.
  3. Select SharePoint List from the Import group. The Get External Data dialog appears (see Figure 22).
    Figure 22. In the Get External Data dialog, you can designate whether you want to import or link to the SharePoint data.

    image

  4. Designate whether you want to actually import the SharePoint data into the Access database or whether you prefer to create links in the Access database to the SharePoint ...

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