Adding a pivot table in Excel 2007 from a QUERY in Access 2007

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neurogenesis - 20 Jul 2007 17:18 GMT

What am I missing here? In Excel 2003 I was able to create a pivot
from a query in a Access 2003 database.

Now when I go to create the pivot in Excel 2007 I only get the Access
table to show up, not the queries.

Process in Excel 2003:

Data>PivotTable and PivotChart Wizard> External Data Source>Get
Data>MS Access Database>(Select Database)>(Select Access Query and
move from "Available tables and columns" to "Columns in your
query">Next>Next>Next>Finish

Process in Excel 2007:
Insert Tab> PivotTable>Use an external data source>Choose
Connection>Browse for more>(Select Database)>Open
...it is at this point in Excel that I cannot see the queries that I
generated in Access.

Thanks in advance for your help.

Reply to this Message

Debra Dalgleish - 20 Jul 2007 17:48 GMT

In Excel, on the Data tab, click From Access
Select your database, click Open
Select the query, click OK
Select PivotTable report, click OK

> What am I missing here? In Excel 2003 I was able to create a pivot
> from a query in a Access 2003 database.
[quoted text clipped - 16 lines]
>
> Thanks in advance for your help.

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Neurogenesis - 23 Jul 2007 14:31 GMT

> In Excel, on the Data tab, click From Access
> Select your database, click Open
[quoted text clipped - 27 lines]
>
> - Show quoted text -

This still only shows the tables though, it doesnt show queries.

Process I can only follow (as it allows):

>From Data Tab>From Access> Chose database>Click open>(this is where it

blows up, it then asks me to chose what table I want to use, none of
the queries are listed)

Thanks!

Reply to this Message

Debra Dalgleish - 23 Jul 2007 19:03 GMT

The queries show up for me, except for Union queries.
Is this the same database that you used in Excel 2003?

>>In Excel, on the Data tab, click From Access
>>Select your database, click Open
[quoted text clipped - 36 lines]
>
> Thanks!

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message

Neurogenesis - 23 Jul 2007 19:17 GMT

> The queries show up for me, except for Union queries.
> Is this the same database that you used in Excel 2003?
[quoted text clipped - 45 lines]
>
> - Show quoted text -

I've tried both DB created on 2003 and 2007, same issue on both. Thing
is, I wrote all of the queries (which half of them are UNIONs, in the
SQL view...I didn't use the GUI)

Reply to this Message