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.