Error "Invalid use of '.', '!', or '()'. in query expression" returned when adding columns from multiple tables from Microsoft Database Files(.mdb) into one TIBCO Spotfire data table
Article ID: KB0076339
Updated On:
| Products | Versions |
|---|---|
| Spotfire Analyst | All Versions |
Description
When loading data from .mdb file and trying to add all the columns from two different tables into one table using an inner join like the following query:
The following error message is seen:
OleDbException at Microsoft JET Database Engine:
Invalid use of '.', '!', or '()'. in query expression '`Authors`.'au_fname'= `Employees`.'fname''. (HRESULT: 80040E14)
The following error message is seen:
OleDbException at Microsoft JET Database Engine:
Invalid use of '.', '!', or '()'. in query expression '`Authors`.'au_fname'= `Employees`.'fname''. (HRESULT: 80040E14)
Issue/Introduction
This article explains why the error "Invalid use of '.', '!', or '()'. in query expression" is returned when adding columns from multiple tables from Microsoft Database Files(.mdb) into one TIBCO Spotfire data table.
Resolution
The reason the above query was failing was because single quotation marks are used to represent the column name. To resolve, update the query to use the backtick(`) instead of the single quotation(') when referring to the table or column name.
Additional Information
Doc: How to Import Data from OLEDB data source
Feedback
Yes
No
Powered by
