Pivot Table in Excel not reading Access Query

[Lee]

I use Access link to a SQL server database and then run queries in Access. I
wanted to do a Pivot Table in Excel because of other users able in the
office. I can't get Excel to import or even show one of the queries in
Access where I use MonthName to get the month's name and not a number. If I
use the month's number, all is well. It is not a big deal just wondering why
it won't work.
Is there a way to change the number to a name in Excel's Pivot Table as I
can' get =Text(cell,"MMMM") to work in the calculated field.
Thanks for any help.
Lee