Article ID: 208838 - View products that this article applies to.
This article was previously published under Q208838
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).
This article describes what happens to Microsoft Access groups, calculations, and labels when you export a report to Microsoft Excel.
In Microsoft Excel, the fields are laid out in columns with each row representing a separate record. The Microsoft Access Output To command uses the Outline feature of Microsoft Excel to format the report's groups.
Group Headers and FootersUnlike groups in Microsoft Access, Microsoft Excel outlines have only a header or a footer, not both. For this reason, only information in the report's group header is included in the output. To include group information in the output, place the information in the group header instead of the group footer.
NOTE: In earlier versions of Microsoft Access and in Microsoft Access 2002, sums are able to be exported from a group footer. This is not the case for Access 2000. For additional information, click the article number below to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/253639/EN-US/ )ACC2000: Microsoft Access Report Totals Are Missing When You Export Report to Microsoft Excel
CalculationsAll calculations in the detail or group header sections are included in the output. Excel functions are not used to calculate expressions in the Access Report. Instead, the results of an expression calculated in Access, are stored in the appropriate cell according to the location of the text box.
LabelsColumns are labeled according the Name property of the text boxes they represent.
ColumnsTo avoid differences in column order between the report and the exported spreadsheet, Top align the controls in the Detail section of the Access report. The columns in the exported Excel spreadsheet appear in order of the highest text box control in the Detail section of the report. For example, if the Top property of the first text box on the left is .001 and the Top property of the second text box is 0, the values for the second text box on the Access report appear in the first column of the exported Excel spreadsheet.
For more information about the OutputTo command, click Microsoft Access Help on the Help menu, type OutputTo Action in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
Article ID: 208838 - Last Review: April 25, 2003 - Revision: 2.0