KNOWLEDGE BASE

Failed to create an export with error message "Microsoft JET database error 0x80040E3E"


Published: 18 Jan 2019
Last Modified Date: 23 Jan 2019

Issue

When creating an MS Access export table of blended data, inclusive of linked fields (from multiple secondary data sources) with identical names, the following error may occur:

Bad Connection: Tableau could not connect to the data source.
Microsoft JET database error 0x80040E3E:cannot define field more than once 
​​​​​​​

Environment

  • Tableau Desktop 2018.2.3
  • Tableau Desktop 2018.3.1
  • Excel

Resolution

Use one of the following options as a workaround for the issue:

  1. Rename the field in either of the data sources to a different name
  2. Do not drag two identically named fields to the same view
  3. Use export crosstab table instead

Cause

This is related to a known issue that is currently under investigation with Tableau Development.

Did this article resolve the issue?