Why not do it the other way round?

In Excel create a pivot table with the Access query as a source.