Excel as Database Problem Generating XSD Strings

Error:

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$'.

 

Cause:

The Schema version of the Advanced Database Schema is incorrect

 

Solution:

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

0 Comments

Article is closed for comments.