Database Reference
In-Depth Information
Whichever method you choose, before you import a SharePoint list into a new table in an
Access database, it is a good idea to do the following:
Make a note of the SharePoint site's URL.
1
On the SharePoint site, identify the lists you want to copy to the database, and then
decide whether you want the entire list or just a particular view.
TIP
You can import multiple lists in a single import operation, but you can import
only one view of each list. If one of the standard views doesn't fit your needs, create
a custom view containing only the fields and list items you want before proceeding
with the import process.
2
Review the columns in the source list or view, and identify the database into which
you want to import the lists.
TIP
When you import a SharePoint list, Access creates a table with the same name
as the source list. If that name is already in use, Access appends a number to the
new table name—for example, Contacts1. Access will not overwrite a table in the
destination database or append the contents of a list or view to an existing table.
3
To import the SharePoint list or lists you have identified, follow these steps:
Open a new blank database.
1
On the
External Data
tab, in the
Import & Link
group, click the
More
button. Then
click
SharePoint List
to start the
Get External Data
wizard, which displays a list of
known SharePoint sites. (You are not limited to the sites in this list.)
2
On the
Select the source and destination of the data
page, in the
Specify a
SharePoint site
area, click the address of the site you want to connect to, or
enter it in the box.
3
Click either
Import the source data
or
Link to the data source
. Then click
Next
.
4
If prompted to enter your site credentials, do so.
5
On the
Import data from list
page, in the
Import
column, select the check box of
each list you want to import into the database.
6
