Microsoft® Windows® SharePoint® Services 3.0 Step by Step

Importing a List to an Access 2007 Table

By using Access 2007, you can create a new table by importing data from an external data source such as Lotus 1-2-3, a Paradox or dBase database, Excel 2007 workbook, Office Outlook 2007 or Microsoft Exchange folder, XML document, ODBC data source, and SharePoint Web site. The new table becomes an integral part of your database, and the data are not affected by subsequent changes made to the data source after they are imported.

In this exercise, you will import data from a SharePoint list.

Note

USE the ExpImpWideWorldImporters.accdb database located in the Documents\Microsoft Press\SBS_WSSv3\Chapter 13 folder. Remember to use your SharePoint site location in place of http://wideworldimporters in the following ...