Excel ODBC data source not working after upgrade 2014
Now when opening one of the map that was perfectly working before (and the source file hasn't changed since), it throws an error :
and after you hit OK
The original map was setup to use ODBC as the driver for the Excel file input, now this doesn't seem to work anymore after the upgrade…I've tried to rebuild the link, but no success..
Any suggestion on how to fix this ?
Is there a COUNT statement in the data source of the map that won't validate? That is a sql function however it isn't supported by Excel ODBC drivers so if that is in there it should be removed from the query if the source is excel.
No there was no COUNT statement in the ODBC source definition, and honestly I was wondering from where this was coming… as my attempts to make if work failed, I deleted it completly and rebuilt if from scratch, knowing that all I needed to get my data was to do a select statement from my input file defined name range and voil
If you would like to submit an answer or comment, please sign in to the eOne portal.