Hi,

I'm trying to create a pivot table using data from an MS-Access query. I am
using the pivot table and pivot chart wizard. Here is what I am doing:

On step 1 I select "External data source".
Click on "Get Data"
I choose "MS-Access database*"
I choose the database I want to use.
I choose the query I want to use.
I don't want to add any filters or sorts because they are already in the
query so I click next to those prompts.
I leave the "Return data to microsoft excel" selected and click on finish.

I then get a message from Microsoft Query stating "ODBC connection to 'ODBC
connection name' failed."

What do I need to do to get this working?