Excel files generated by Kendo Excel Export cannot be imported by the MS ODBC Driver. The error reported in this forum thread is:
External table is not in expected format.
If the file is opened and resaved with Excel or if the styles.xml file is replaced with any styles.xml generated by MS Excel, the error does not occur. When compared the styles.xml of Excel does not contain a numberFormat, no other obvious major differences at first glance:
<numFmts count="2"> <numFmt formatCode="#" numFmtId="165" /> <numFmt formatCode="#" numFmtId="166" /> </numFmts>
If possible, modify the styles.xml template to enable seamless use with OleDB