Following error occurs in Toad 3.0.1 Pro Edition and latest 3.1 Beta when executing a Cross-Connect query with an Excel or Access table having a table name called "Day Coordinator”. This table can be queried with any other database table and error persists:
"Error 4208 'ODBC data source returned an error: Syntax error (missing operator) in query expression 'Day Coordinator'.' from HUB"
WORKAROUND:
None
STATUS:
Waiting for fix to be released in a future version of Toad for Data Analysts.