Exporting to Microsoft Excel
You may want to disseminate information from your database to colleagues who do not themselves have a database application, however they will often have access to Microsoft™ Excel.
To export data to Microsoft Excel:
- Select .
- Select an entity or link type from the list.
- Specify which records to export.
- In the Fields to Export area, turn on the checkboxes next to the fields that you want to export, turn off the check boxes of fields that you do not want to export.
In the Totaling Functions area, turn on the check box next to the Microsoft Excel function that you want to apply to the data. The functions only apply to numerical fields. The functions are:
Function For each number field returns... Microsoft Excel function Lowest The lowest value MIN Highest The highest value MAX Average The average value AVERAGE Sum of A total SUM Standard deviation The standard deviation STDEV Mode The most frequently occurring value MODE
- Click Export.