Exporting Data from a Table or Query

To export an Access table to a new Excel workbook:

1. Select Export... from the File menu.
2. Click the Save as type: arrow.
3. Click the type of file you would like to export the data to.
4. Type the filename in the File Name box.
5. Click Export All.

To export data from a table or query, open the File menu and select Export... In the Save as type: box, select the file type you want to export to. Enter a filename and click Export All.