KNOWLEDGE BASE

Text fields in Access database showing as number value in Tableau


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

Issue

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

Environment

  • Tableau Desktop
  • Access

Resolution

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.

Cause

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?