Skip to main content

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

Rich Talbot
  • Created
Date Posted:
Product: TIBCO Spotfire®

Problem:

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


Solution:

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: 

User-added image 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. Doc: How to Import Data from OLEDB data source

Comments

0 comments

Article is closed for comments.