Forum Discussion
subbu_valliappa
12 years agoContributor
Great, thanks for confirming then.
I tried again without the ACE driver flag
drvExcel := DDT.ExcelDriver(ExcelTestDataFile, SheetName)
but got this error now:
External table is not in the expected format
Got to look into this but another option would be to use ACE driver 32-bit - got to uninstall Office 64-bit first that we have on all our machines. I'll keep on trying.
Thanks a lot for your time, really appreciate that.
I tried again without the ACE driver flag
drvExcel := DDT.ExcelDriver(ExcelTestDataFile, SheetName)
but got this error now:
External table is not in the expected format
Got to look into this but another option would be to use ACE driver 32-bit - got to uninstall Office 64-bit first that we have on all our machines. I'll keep on trying.
Thanks a lot for your time, really appreciate that.