Load the output of a datasheet, form, or report into Microsoft Excel

Load the output of a datasheet, form, or report into Microsoft Excel

  1. In the Database window, click the name of the datasheet, form, or report you want to save and load into Microsoft Excel. To save a selection of a datasheet, open the datasheet, and then select the portion of the datasheet before continuing.

  2. On the Tools menu, point to Office Links, and then click Analyze It With MS Excel.

    The output is saved as a Microsoft Excel file (.xls) in the default database folder. Microsoft Excel automatically starts and opens it.