Access Office Integration (AOI) has a tool called Access Analytics which can be used to extract data in excel. It can be found in the Access tab of excel (where AOI is installed). It can generate a data table and pivot chart and is used as follows:
Click on the Access Analytics button in the Access tab of excel.
Select the required data connection and click Next to open the Output Selections screen.
Choose a Starting Cell by clicking the pop over button to the right of it and selecting a cell on the spreadsheet.
You can select cell A1, but normally it is preferable to choose one slightly in and down - eg B3.
Then Click on the pop over button once more and return to the Output Selections screen.
Use the boxes in the Selected column to choose the fields to return and click Next when ready (you can return to this screen if necessary).
Enter, amend or remove criteria using the Add, Update and Delete buttons. Using filters can drastically reduce the amount of data being returned, and so speed the process up.
The Display button is typically used when revisiting a template having amended it so click Next to proceed.
Tick the Save Template box and add a name if required.
Show Data Sheets is a very useful option as it returns a sheet of the data in a separate tab to allow an overall review, and can be used to check for anomalies.
Click Insert to return the data.