Pivot table from ODBC database problems

A

Andy Cunningham

Hi all,

I'm trying to resolve a problem in creating an Excel
pivot table from an external ODBC data source. The data
is in an Access database set up as an ODBC data source,
and the data can all be read by SQL queries, MS Query
tool etc. However, attempting to pull a particular day
of entries from a particular table into a pivot table
gives a 'Microsoft ODBC driver error' message, followed
by 'Problems obtaining data'.

The data for the day can be accessed via other methods
and appears completely normal. Has anyone seen any
similar situation / know any solutions?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Connection files and pivot tables 0
Pivot table drill down sort 0
How to build / refresh pivot table without ODBC?? 1
Pivot Table with Data Model Connection - getpivotdata #REF error 0
Pivot Table with Data Model Connection - getpivotdata reference issue 0
ODBC Linked Tables 0
Some mail merge fields not pulling into document 2

Top