O'Reilly logo

2007 Microsoft® Office System Step by Step, Second Edition by Joan Lambert, John Pierce, Steve Lambert, M. Dow Lambert III, Curtis D. Frye, Joyce Cox

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

Working with SharePoint List Data in Access

You can work with content from SharePoint lists in Access just as you can with standard database content. You can bring a list into Access in either of two ways: by importing or by linking.

Importing a SharePoint list creates a copy of the list in the destination Access database. During the import operation, you can specify the lists that you want to copy, and, for each selected list, you can specify whether you want to import the entire list or only a specific view. The import operation creates a table in Access and then copies the columns and items from the source list (or view) into that table as fields and records. Changes made to the imported data in Access will not be replicated in SharePoint, and ...

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