Hi Mr Deeds,
You can create a link between Access and Excel to get the data. When I've set this up in the past, I've setup a Query in Access that gets the data I want and then link to it in Excel.
If that "raw" link of data from the Access Query meets your needs, you should be good to go. However, if you need to manipulate the data or format it more, you can do that in Excel (either manually or with VBA).
Hope this helps.