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

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

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.