Working with SharePoint Data Lists

Access 2003 enables you to work with data stored on a Microsoft SharePoint Team Services Web site. SharePoint Team Services sites provide a gathering place for shared documents and meeting workspaces, giving you everything you need to organize projects, communicate with team members , assemble your resources, and share information. SharePoint sites include many different types of lists ”for example, announcements, events, document libraries, links, tasks , contacts, and more ”that you can import into your Access data tables.

To import SharePoint data, begin by opening the database you want to use. Choose Get External Data from the File menu, select Import, and in the Files Of Type field, choose SharePoint Team Services. When prompted, provide the URL of the SharePoint site you want to access, and click OK. The Import SharePoint Team Services Wizard begins (see Figure 17-3).

Figure 17-3: You can import data from all SharePoint lists by using the Import wizard.

Choose the list you want to import, and click Next. Choose the views that you want to import from the displayed list, and click Next again. Finally, click Finish. Access imports the information and places it in a table in the Database window.