KNOWLEDGE BASE

Resolving "Database error: No value given for one or more required parameters" Error


Product(s): Tableau Desktop
Version(s): All
Last Modified Date: 16 Aug 2016

After connecting to an Excel data source, you might see the following error message: 

"Database error 0x80040E10: No value given for one or more required parameters."

This error message appears because of limitations in the Microsoft Jet Database Engine. The error can occur for one of the following reasons:

  • A column requested by a custom SQL statement does not exist in the Excel data. To resolve this issue, remove the column from the custom SQL statement.

  • When connected to Excel 2007 data, Jet cannot send one or more of the column headers in the Excel file to Tableau because there are leading or trailing spaces in the data. To resolve this issue, remove the leading or trailing spaces from the Excel file to allow Jet to send the column information to Tableau.

    In the following example, the Quantity field in the Excel data contains leading spaces. 

Tableau cannot connect to the spreadsheet because of the leading space in the "Quantity" column header. When you begin to drag dimensions and measures into the view, you might see the error message.

Note:Jet-based errors can only occur in workbooks created with Tableau Desktop 8.1 and earlier that use Excel and text file data sources, workbooks that use the legacy connection, or workbooks that use Microsoft Access data sources. To avoid Jet-based issues, consider upgrading your Excel data source. For more information, see Upgrading Data Sources in Desktop Help. 

 

Alternate Search Terms:excel, error, database, 0x80040E10, an error occurred while communicating with data source, JET
Did this article resolve the issue?