Microsoft Access prompts you to specify the location of the database and opens a table with the exported data.
Link a Datasheet view to AccessYou can link a Datasheet view to Access by creating in Access a linked table with the Datasheet view.
- In the Datasheet view toolbar, click Task Pane to display the Task Pane for the Datasheet view.
- Click Create a linked table in Access.
- 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.