Learn how to export an Access database to Excel. When you export data from Access to Excel, Access stores the copied data in a file that can be open in Excel.

Launch Microsoft Access on your computer. Click the "File" tab and then click "Open." Open the Access database that contains the report you want to export to Excel. Click the "Navigation Pane" on ...

Launch Excel and open the spreadsheet you wish to load into Access. Verify that the spreadsheet's column names match the Access table's field names.