Last Modified Date: 20 Jul 2023
Environment
- Tableau Desktop
- Microsoft Access
Resolution
Option 1
Copy the SQL that generates the missing query within Microsoft Access and paste that into the Custom SQL connection to Microsoft Access within Tableau Desktop.Option 2
- In Microsoft Access, use the "Alike" function, instead of the "Like" function.
- Use the percent (%) wildcard character instead of the asterisk (*) wildcard character.
Cause
- Microsoft Access does not allow connections to union queries, nor does it allow you to create external union queries.
- Known issue relating to the ANSI Query Mode utilized by Microsoft Access.
Additional Information
- Microsoft Access utilizes ADO (ActiveX Data Objects) in the creation of SQL statements with the function "Like" and wildcard "*".
- For more information, see Using the Right Wildcard Characters in SQL Statements in Microsoft Help.
- See Connecting to Access UNION queries and Union query in access not pulling through into Tableau? in the Community Forums for additional details (note: you must login to view the first thread)
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials