Some Microsoft Access Queries Not Available for Selection

Published: 29 Jul 2013
Last Modified Date: 08 Jan 2019


When connecting to Microsoft Access from Tableau Desktop, some queries might not be available.


  • Tableau Desktop
  • Microsoft Access


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

  1. In Microsoft Access, use the "Alike" function, instead of the "Like" function.
  2. Use the percent (%) wildcard character instead of the asterisk (*) wildcard character.


  • 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.
Did this article resolve the issue?