Integrating Microsoft® Office Access 2007 and Microsoft® SharePoint Server 2007

Section 4. Publishing Data to a SharePoint Site

When you publish data to a SharePoint site, you first copy it to the site and then create links to it from within Access. You can then run your queries, forms, and reports from within Access. The Move to SharePoint Site Wizard assists you with the process of creating the lists in SharePoint, maintaining the relationships between them and creating links to them within Access. Here's how the wizard works:

1. Click to select the External Data tab.
2. Click the Move to SharePoint button within the SharePoint Lists group. The Move to SharePoint Site Wizard appears (see Figure 7).

   Figure 7. The Move to SharePoint Site Wizard walks you through the process of moving Access tables to SharePoint lists.

3. Designate ...