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

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