Product Tour
Connecting to Access UNION queries
Submitted by acotgreave on July 21st, 2008
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
Subscribe to the comments on "Connecting to Access UNION queries"
Comments
July 25th, 2008
Marc Rueter
Posts: 28
Joined October 2007
Comment Link: #
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.
August 12th, 2008
acotgreave
Posts: 51
Joined December 2007
Comment Link: #
Thanks for the info Marc - that's sorted out my problem.
Andy
Post new comment