Description: This solution discusses how to resolve the error: ERROR [42000] [Microsoft][ODBC Excel Driver] Syntax error in FROM clauseEnvironment: All
Versions: All
Answer:
This error can occur if there is a space in the column header for the MasterIDs.xls file. For more information on how to use the MasterID file, please see this Knowledgebase solution.
The MasterIDs file need to have the following columns, in this order, with these column headers. It is not required to have values in each column, but the column headers must be present.
Refer to the ImportOmatic User Guide for additional information.