Sounds like you may not have "rights" to the channel or the data.....check
with you MIS to see if you do............if you had then some time ago, maybe
the path has been changed.........

hth
Vaya con Dios,
Chuck, CABGx3



"Jim Moberg" wrote:

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?