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

Troubleshoot exporting Datasheet views

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.

Exporting to Microsoft Office applications in general

I get the message "Office application not available."

You are attempting to perform a task that requires either Microsoft Access 2003 orMicrosoft Excel 2003. Install the program and try again.

Exporting to Microsoft Excel

I can't export my Datasheet view to Microsoft Excel.

Check your version of Excel. You can export a Datasheet view to only Microsoft Excel 2003 or later.

Error message "This operation cannot be performed because either Microsoft Excel 2003 is not installed on this computer, or it is not the default version."

This operation cannot be performed because either Microsoft Excel 2003 is not installed on this computer, or it is not the default version.To make Excel 2003 the default version, double-click Add or Remove Programs in Control Panel. Click Change or Remove Programs , and then click Microsoft Office . Click Change , click Reinstall or Repair , and follow the instructions.

Exporting to Microsoft Access

I can't export or link my Datasheet view to Microsoft Access.

Check your version of Access. You can export a Datasheet view to only Microsoft Access 2003 or later.

I need to export or link a list in Windows SharePoint Services to a table in Access 2000 format.

You can only export or link the Datasheet view of a list to a table in Access 2003. This means you must have Access 2003 installed. However, you can still export or link to a table in Access 2000 format through Access 2003 because Access 2003 supports databases created in Access 2000:

  1. Open Access 2000 and create a database. This database is in Access 2000 format.

  2. Close Access 2000.

  3. In Windows SharePoint Services, export or link the Datasheet view of your list to this existing database in Access 2003.

Note: You can apply this procedure to Access 2002 if you need to export or link to a table in Access 2002 format. Access 2003 supports databases created in Access 2000 and Access 2002.

The Microsoft Access table I am trying to connect to is unavailable.

This can be caused by a number of possible reasons:

  • You do not have permissions to create or modify the database.

  • The database is read-only.

  • The database is secured using user-level security, but the computer that is used to automate Access is not joined to the correct workgroup information file. For more information on user-level security, see "About user-level security" in Access help.

If you are trying to export or link a Datasheet view to Access, import or link to that view from Access instead. If you are trying to create an Access report with that view, import the view into Access and generate a report from there.

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