Error when creating PivotTable from External Data Source

[ianward]

Afternoon all, I am wondering if anyone else has come accross a problem that I am encountering when creating a PivotTable from an External Data Source?

I am running WinXP SP2, Office 2003 SP3

I need to run a pivot in excel based on a query in Access (there are in excess of 130,000 rows, so I cant import the data into an excel worksheet)

When i attempt to create a pivot by using "External Data Source", browse to MS Access Query, I can see the database, browse to the Query in question add the relevant Fields" I then the the following Error:

"The Microsoft Access Database engine cannot find the input table or query 'mdb.QueryName'. Make sure it exists and that it is spelt correctly"

I can create this without any problem what-so-ever on my colleagues machine - the only difference is that her machine is running Office 2003 SP2 where i am on SP3... - Has anyone else come accross this and/or does anyone know of a workaround to this as my forehead is now starting to appear flat with constantly banging my head on the desk in frustration.

Many Thanks - Ian

 

[ianward]

I asked our IT department to come and re-install office, so I am now running Office 2003 without any Service Packs.... and it still doesnt work, so I guess my problem was not with SP3. Could it be Microsoft Query?

 

[ianward]

The plot thicken's - when looking in ODBC Drivers - I notice i have 2 MS Access Drivers... v4.00.xxx and v12.00.xxx - I guess the latter must have been installed after i had to install the 2007 compatibility pack. - I have since removed the compatibility pack but the drivers remain - If i can remove the newer driver i will recheck and post back my findings.

Ian