Export a table or query to a Windows SharePoint Services list

You can use the Export to Windows SharePoint Services Wizard in Access 2003 to export tables or queries to lists in Windows SharePoint Services.

1. In the database window, select a table or a query.
2. On the Access toolbar, click File.
3. Click Export.
4. In the Export Table dialog box for the selected table or query, for Save as type, select Windows SharePoint Services. This opens the Export to Windows SharePoint Services Wizard.
5. Specify a Windows SharePoint Services site that you want to export to.

   Note  You can only export tables or queries to a site that uses Windows SharePoint Services 2.0 or later.

6. The name of the list defaults to the name of the table or query you are exporting. You can use the default name or type a different name.
7. Optionally, type a description for the list. This description is also the value of the description property of the table or query being exported.
8. Check Open the list when finished if you would like Windows SharePoint Services to open the list automatically after exporting.

   Note  Windows SharePoint Services opens the list in Datasheet view by default. You can change the default view of the list in Windows SharePoint Services.

9. Click Finish.