KNOWLEDGE BASE

Not All Records Imported When Connecting to Access Queries


Published: 28 Jun 2013
Last Modified Date: 10 Oct 2016

Issue

After connecting to a Microsoft Access query from Tableau Desktop, the data in Tableau Desktop might be different than the results of the original Microsoft Access query. Upon investigation, some records were not imported from Microsoft Access.

Environment

  • Tableau Desktop
  • Microsoft Access

Resolution

In Microsoft Access, convert the query to a table, and then connect to the table from Tableau Desktop. For more information, see Create a make table query on Microsoft Office Support page.
Did this article resolve the issue?