O'Reilly logo

Microsoft® Windows® SharePoint® Services 3.0 Step by Step by Penelope Coventry, Todd C. Bleeker, Bill English, Olga M. Londer

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required