Excel as Database Problem Generating XSD Strings


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




Have more questions? Submit a request


Article is closed for comments.