Export (0) Print
Expand All
ABS
AND
ASC
COS
DAY
DDB
EXP
FV
IF
INT
LEN
LN
LOG
MAX
Me
MID
MIN
MOD
NOT
IS
NPV
ODD
OR
PI
PMT
PV
SIN
SLN
SUM
SYD
T
TAN
VAR
Expand Minimize

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft