forums

Use these forums to ask questions and discuss Tableau.

Connecting to Access UNION queries

Posted July 21st, 2008 by acotgreave
in Data Sources and Performance

I have a UNION query in my Access database. When I try to connect to it in Tableau, it does not appear in the list of queries. I also tried a Custom SQL command, writing the SQL for the UNION query, but that gave me a JET error.

Does Tableau not support connecting to Access UNION queries? Is there any workaround?

Thanks

Andy

Add new comment

Comments

On July 25th, 2008 Marc Rueter said:

This isn't a Tableau limitation, rather an Access limitation.

Access does not allow connections to union queries. Nor does it allow you to union queries from outside of access. the easiest solution is to simply copy the SQL that generates the queries from Access and paste it into Tableau.

All the JET errors are Microsoft specific (JET is a windows component) and you can find lots of help on the web or via MSDN.

reply
On August 12th, 2008 acotgreave said:

Thanks for the info Marc - that's sorted out my problem.
Andy

reply
Syndicate content Subscribe to the comments on "Connecting to Access UNION queries"