OBBC=connection to ... failed.
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?
|