Microsoft Office Tutorials and References
In Depth Information
Sending a Report to Another Application
The Export –
If you just want to export the data without any associated formatting,
don’t select any of the check boxes.
4. Click OK.
Access creates an Excel spreadsheet with a column for each field and a
row for each record on the report.
Another Export dialog box appears, asking whether you want to save the
steps you took to perform this export operation.
5. Decline the offer.
Usually, it isn’t worthwhile to save these steps.
6. Click the Close button.
Exporting is just that easy!
If your report contains a subreport, Access creates a set of rows for the
subreport below the row for the record in the main report, with the columns
for the subreport fields off to the right. This format makes sense because it
keeps the data organized, with a column for each field, but it’s hard to read.
Exporting your report to Microsoft Word
You can export an Access report as a Word document in a similar way.
Actually, the exported file is an RTF (Rich Text Format) file that can be
opened in Word or any other program that supports RTF.
Exporting to an RTF file is almost identical to exporting to an Excel file. To
export to RTF, follow the steps in the preceding section for exporting an
Excel spreadsheet, but click the More button in the Export group on the