I am trying to connect to my .xslx file as a DB. Everything is fine till I try and create the Adv. Database Schema it appears that a quote is getting inserted into the wrong location so the ODBC driver throws an error.
Problem In Generating XSD Strings, com.adeptia.indigo.utils.IndigoException: Error in executing query = SELECT StateID,"State Code",Name FROM "[State$]", Error: [Microsoft][ODBC Excel Driver] Invalid bracketing of name '[State$'.
The Schema version of the Advanced Database Schema is incorrect
Un-check the Schema Version 2.0 option in the Advanced Properties section of the Advanced Database Schema when creating a new activity