Save an object's output as a Microsoft Excel or Rich Text Format file
- In the Database window, click the name of the object you want to save. To save a selection of a datasheet, open the datasheet and select the portion of the datasheet before continuing.
- On the File menu, click Export.
- In the Save As Type box, click Microsoft Excel 5-7 (*.xls), Microsoft Excel 97-2000 (*.xls), or Rich Text Format (*.rtf).
- Click the arrow to the right of the Save In box, and select the drive or folder to save to.
- In the File Name box, enter a name for the file (or use the suggested name).
- If you are saving as Microsoft Excel 5-7, Microsoft Excel 97, or Microsoft Excel 2000, select the Save Formatted check box. If you are saving the object in Rich Text Format, the Save Formatted check box is selected automatically.
- Click Save All to save the entire datasheet or Save Selection if you selected a portion of the datasheet in Step 1.