Text fields in Access database showing as number value in Tableau

Published: 04 Dec 2017
Last Modified Date: 05 Dec 2017


When connecting to a table in an Access datasource, some of the fields that show string values in Access may show seemingly unrelated numeric values in Tableau Desktop


  • Tableau Desktop
  • Access


When setting up the Access data source, join the main Access table with all of the necessary lookup tables to provide the string values associated with the ID numbers.


Tables and queries in Access can be configured to automatically pull in values from lookup tables for specified ID fields. This automatic lookup does not get implemented, when queried from an outside source.
Did this article resolve the issue?