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.1. Exporting SharePoint Lists to Access

To export a SharePoint list into Access, you can start from SharePoint or Access. Let's first start from SharePoint. Navigate to your SharePoint site, and open the list you want to export. From the menu bar at the top of the list, click Actions to open the drop-down menu and select Open with Access as shown in Figure 6-1.

A message box, shown in Figure 6-2, prompts you for two pieces of information. First, you must specify a location and name for a new or existing database. Access stores each database as a separate file. Further, it can store the file in any directory. By default, SharePoint attempts to create a database in your Documents and Settings folder under My Documents. Also by default, 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