Sending a datasheet to Excel not only allows it to be viewed by people more accustomed to using the Excel program as opposed to Access, but it also gives you the ability to edit and analyze the datasheet outside of Access.
Open the datasheet you want to export
Choose File: Export from the Menu bar
Figure 14. Export Report Dialog Box
3. Next to Save as type, click the drop-down arrow and choose Microsoft Excel 97-2003 (*.xls)
4. Next to File Name, enter a file name
5. Click Export All
6. Switch to Microsoft Excel to open your exported file