How to Update SharePoint Lists With Access Table Data

Updating SharePoint lists with Access table data is moderately challenging.

The Microsoft Office SharePoint Server (MOSS) application gives network administrators the tools required to quickly set up a company intranet. The intranet consists of SharePoint websites that users access via their Web browsers. Each SharePoint website has a number of lists that contain user-inputted data. This data can be amended using Microsoft Access-like tools, all within SharePoint, so that fine customizations can be made. Once done, the data is automatically saved within the list by SharePoint.

Things You'll Need

• SharePoint server

Instructions

1. Navigate to the SharePoint website.

2. Navigate to the list you wish to amend.

3. Click "Actions," then from the drop-down list click "Edit in Datasheet."

4. Click on the arrow on the right-hand side of the page.

5. Click "Create linked table in Access."

6. Click "OK."

References

• Microsoft: Integrate Access and SharePoint Data