Export or link a Datasheet view to Access

Archived content. No warranty is made as to technical accuracy. Content may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Export a Datasheet view to Access

  1. In the Datasheet view toolbar, click Task Pane to display the Task Pane for the Datasheet view.

  2. Click Export to Access .

  3. Choose to export the Datasheet to an existing database or a new database and click OK .

Microsoft Access prompts you to specify the location of the database and opens a table with the exported data.

Link a Datasheet view to Access

You can link a Datasheet view to Access by creating in Access a linked table with the Datasheet view.

  1. In the Datasheet view toolbar, click Task Pane to display the Task Pane for the Datasheet view.

  2. Click Create a linked table in Access .

  3. Choose to export the Datasheet to an existing database or a new database and click OK .

Access prompts you to specify the location of the database and opens a linked table with the exported data.

Update Datasheet view with changes in linked table

After you update the linked table, on the Datasheet view toolbar, click Refresh Data to refresh the Datasheet view.

Update linked table with changes in Datasheet view

In Windows SharePoint Services, after you change the data in the Datasheet view, you can see the changes in the linked table when you re-open it.

If, for some reason, you change the location of the Datasheet view, you can use the Linked Table Manager to synchronize the change between the Datasheet view and the linked table. For more information on the Linked Table Manager, see Access help.