Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. Unless you install the Office 2007 suite Service Pack 2, you cannot export a report to an Excel format in Access 2007

Unless you install the Office 2007 suite Service Pack 2, you cannot export a report to an Excel format in Access 2007

Symptoms

In Microsoft Office Access 2007, you may experience one or more of the following symptoms.

Symptom 1

Consider the following scenario. You try to export a report to a Microsoft Excel format. To do this, you right-click the report in the navigation pane, and then you point to Export. In this scenario, you may find that the Excel option is unavailable.

Symptom 2a

Consider the following scenario. You try to export a report to an Excel format by using the OutputTo macro action or the
SendObject macro action. In the macro action, the value of the
Object Type argument is Report. In this scenario, the option to export the report to the Excel format does not appear in the Output Format list..

Symptom 2b

Consider the following scenario. You run a macro that was created in an earlier version of Access. The macro has the OutputTo action or the SendObject action. In the macro action, the value of the Object Type argument is Report, and the value of the Output Format argument is
Microsoft Excel 97-2003. In this scenario, you may receive the following error message:
The format in which you are attempting to output the current object is not available. Either you are attempting to output the current object to a format that is not valid for its object type, or the formats that enable you to output data as a Microsoft Excel, rich-text format, MS-DOS text, or HTML file are missing from the Windows Registry. Run Setup to reinstall Microsoft office Access or, if you're familiar with the settings in the Registry, try to correct them yourself. For more information on the Registry, click Help.
When you click
OK in the Action Failed dialog box, error 2950 is displayed.

Symptom 3

Consider the following scenario. You run a Microsoft Visual Basic for Applications (VBA) procedure that contains the SendObject method. In this method, the value of the
ObjectType argument is acSendReport, and the value of the OutputFormat argument is
acFormatXLS. Alternatively, you run a VBA procedure that contains the OutputTo method. In this method, the value of the
ObjectType argument is acOutputReport, and the value of the OutputFormat argument is
acFormatXLS. In this scenario, you may receive the following error message:
Run-time error '2282': The format in which you are attempting to output the current object is not available.

↑ Back to the top

Resolution

To resolve this issue, upgrade to the 2007 Office suite Service Pack 2. With Access 2007 Service Pack 2, you can export a report to an Excel format in Access 2007.

↑ Back to the top

Workaround

If you cannot install the 2007 Microsoft Office suite Service Pack 2, you may use one of the following workarounds, depending upon the symptom you receive.

Workaround 1

To work around symptom 1 in the "Symptoms" section, use one of the following methods.

Method 1

In the navigation pane, right-click the table or query that is bound to the report, point to Export, and then click
Excel. Then, follow the wizard to finish the export.

Method 2

In the navigation pane, right-click the report that you want to export, point to Export, and then select another format. For example, select one of the following formats:
  • Word RTF file
  • PDF or XPS
  • Access Database
  • Text File
  • XML File
  • Snapshot Viewer
  • HTML Document

Workaround 2

To work around symptom 2a and symptom 2b in the "Symptoms" section, use one of the following methods.

Method 1

In the macro action, change the value of the Object Type argument to either Table or
Query. Additionally, change the value of the Object Name argument to the record source of the report.

Method 2

  1. In the Action Arguments for the
    OutputTo macro action or SendObject macro action, select another format in the Output Format list. For example, select one of the following formats:
    • HTML
    • Rich Text Format
    • Snapshot Format
    • Text Files
  2. Change the value of the Output Fileargument to the correct file name extension.

Workaround 3

To work around symptom 3 in "Symptoms" section, use one of the following methods.

Method 1

  1. In the VBA procedure, change the value of the
    ObjectType argument to one of the following:
    • acSendTable
    • acSendQuery
    • acOutputTable
    • acOutputQuery
  2. Change the value of the ObjectNameargument to the record source of the report.

Method 2

  1. In the VBA procedure, change the value of the
    OutputTo argument to another value. For example, change the value of the OutputTo argument to one of the following values:

    • acFormatPDF
    • acFormatRTF
    • acFormatSNP
    • acFormatTXT
    • acFormatXPS
  2. Change the value of the OutputFileargument to the correct file name extension.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This issue was fixed in the 2007 Microsoft Office suite Service Pack 2.

↑ Back to the top

More Information

To use one of the following file formats in the 2007 Microsoft Office system, download the corresponding 2007 Microsoft Office add-in:
  • PDF
  • Snapshot
  • XPS
The following table lists these file formats, their corresponding add-ins, and the Microsoft Web sites for downloading the add-ins:

File format2007 Microsoft Office add-inMicrosoft Web site
PDFMicrosoft Save as PDF or XPShttp://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041
PDFMicrosoft Save as PDFhttp://www.microsoft.com/downloads/details.aspx?familyid=F1FC413C-6D89-4F15-991B-63B07BA5F2E5
SnapshotSnapshot Viewer for Microsoft Accesshttp://www.microsoft.com/downloads/details.aspx?FamilyID=b73df33f-6d74-423d-8274-8b7e6313edfb
XPSMicrosoft Save as PDF or XPShttp://www.microsoft.com/downloads/details.aspx?FamilyID=4d951911-3e7e-4ae6-b059-a2e79ed87041
XPSMicrosoft Save as XPShttp://www.microsoft.com/downloads/details.aspx?familyid=BCE8F991-F0A4-47A0-866B-2FD84A329E02

↑ Back to the top

Keywords: kbexpertiseinter, kbtshoot, kbprb, kb

↑ Back to the top

Article Info
Article ID : 934833
Revision : 3
Created on : 4/18/2018
Published on : 4/19/2018
Exists online : False
Views : 262