• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

15. Office Web and SharePoint > 15.1. Work with SharePoint Data from Access

15.1. Work with SharePoint Data from Access

Problem

Windows SharePoint Services makes it easy to create collaborative, team-based web sites consisting of various lists and documents. Is it possible to use Access as a frontend to SharePoint data?

Solution

Tip

This solution requires Access 2003 and a web server running Windows SharePoint Services.

Access 2003 supports the linking to (and importing of) SharePoint lists and document libraries. To link to a SharePoint data source, follow these steps:

  1. Select File Get External Data Link Tables... to open the Link dialog box. Under the Files of Type dropdown control, select Windows SharePoint Services (WSS). Access starts the Link to Windows SharePoint Services wizard as shown in Figure 15-1.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint