About exporting a Datasheet view
|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.|
You can export a Datasheet view to Microsoft Access or Microsoft Excel. With Access, you can export the view to a table in a new database or to an existing database.You can also choose to export to a static table, or export to and create a linked table in Access.With Excel, you can export the Datasheet view to an existing worksheet, a new worksheet or a new workbook. This also creates a link between the Datasheet view and the worksheet and data changes in one can be syncrhonized in the other.
Exporting to Access
When you export from Microsoft Windows SharePoint Services to Access, you are creating a static table in Access with data from Datasheet view. However, changes you make in that view will not be reflected in the static table, and changes in the table will not be synchronized in Datasheet view.
Creating a linked table in Access
When you create a linked table in Access from Windows SharePoint Services, you are creating a new table in Access with data from the Datasheet view. A link is created between the view and the table. You can change the data in Datasheet view and the changes are automatically reflected in the table. Similarly, you can change the data in the table and the changes are automatically reflected in Datasheet view.
Note: There are columns in some types of lists that are modifiable in the Datasheet view in Windows SharePoint Services, but are read-only in linked Access tables.
Exporting and linking to Excel
When you export and link from Windows SharePoint Services to Excel, you are exporting data from Datasheet view to Excel and creating a link to the Excel worksheet. This synchronizes the data between Datasheet view and the worksheet:
You can change data in the Datasheet view and have the changes reflected in the worksheet.
You can change data in the worksheet and update the Datasheet view with the changes.