Export a datasheet to a spreadsheet file

1. In the Database window, click the name of the table, query, view, or stored procedure you want to export, and then on the File menu, click Export.
   
   
2. In the Save As Type box, click the spreadsheet format you want.
   
   
3. Click the arrow to the right of the Save In box, and select the drive or folder to export to.
   
   
4. Double-click an existing spreadsheet, or enter a new name in the File Name box.

   Caution   If you export to an existing spreadsheet file, Microsoft Access deletes and replaces the data in that spreadsheet, unless you export to a Microsoft Excel version 5.0 or later workbook, where the data is copied to the next available worksheet.

   If you selected Microsoft Excel 5-7 or Microsoft Excel 97-2000 (*.xls) in step 3 and you want to preserve fonts, preserve the displayed data from Lookup fields, and preserve field widths, select the Save Formatted check box. Saving files will take longer.

5. Click Save All.

   Microsoft Access creates the spreadsheet file containing the data from your datasheet. Field names from the datasheet are placed in the first row of the spreadsheet.