Importing, exporting, and linking

What's new home

Importing, exporting, and linking to a Microsoft Windows SharePoint Services list from Access

You can perform the following operations with a Windows SharePoint Services list:

• Export the contents of a table or a query to a list.
• Import the contents of a list into a table.
• Link a table to a list.

Exporting and linking to Access data from Windows SharePoint Services

You can now export a list in its Datasheet view from Windows SharePoint Services to a static table or to a linked table in Access. When you export to a static table, you create a table in Access. You can then view and make changes to the table independent of the original list in Windows SharePoint Services. Similarly, you can change the list in Windows SharePoint Services, and that will not affect the table in Access.

When you export to a linked table, you create a table in Access and establish a dynamic link between the table and the list such that changes to the table are reflected in the list, and changes to the list are reflected in the table as well.

Make a local table from a linked table

In Microsoft Office Access 2003, you can make a local copy of the structure or data and structure contained in a linked table.