| |
Export Access Query Data to Excel
 Step 1
Click the name of the Access Query 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.
Export Access Query Data to Excel
Step 2
On the Access menu, select Tools | Office Links | Analyze It With MS Excel.
The output is saved as a Microsoft Excel file (.xls) in the default storage folder for Microsoft Access.
|