Excel pivot + access query

[Ap1_Alan]

Hi everyone,

I had 2 large tables in access (65k rows each), both tables have the exact same column headers. I combined the two using a UNION ALL query. Nothing else was done in access.

Now i'm trying to run an excel pivot table off this query, but when i go through the steps to link to an external source it's only showing the access tables.

Is there something wrong with my query?

SELECT*FROM [Q1]
UNION ALL SELECT*FROM [Q2];

Why wouldnt this show as an external source option?

Thanks in advance!

 

[alansidman]

Not sure why it is not appearing as a linking source, but instead, have you considered just exporting the query to Excel. Are you using an older version of excel that has row limitations?

If you have row limitations, then suggest you create a new query that has your Union Query as its record source. Save this new query. Open it and do a make table query and link the new table to Excel.

Alan

 

[Ap1_Alan]

Using 2007.

Had to make an additional make table query to get it to work. I'm sure this was a basic step i just forgot to do. Haven't used access since college