Chapter 11. Using Windows SharePoint Services with Excel 2003 and Access 2003

In this chapter you will learn to:

  • Import data from an Excel spreadsheet to a list in SharePoint.

  • Use the Datasheet view.

  • Export a SharePoint list to an Excel spreadsheet.

  • Publish an Excel list to a SharePoint site.

  • Export data from an Access database to a list in SharePoint.

  • Import a list to an Access Table.

  • Link an Access table to a SharePoint list.

Microsoft Windows SharePoint Services provides the collaborative backbone to the Microsoft Office System. In previous chapters, you saw how, within Office 2003, you could share and manage documents stored in a SharePoint Web site. You also created SharePoint sites from your Office programs.

This chapter focuses on the integration ...

Get Microsoft® Windows® SharePoint® Services Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.