Forum Discussion
baxatob
Community Hero
In the second case you are passing third parameter as True. This should use ACE Driver instead of ODBC:
1st case: set xlDriver = DDT.ExcelDriver("C:\Script- Resources\BatchRun\myfile.xls","Sheet1",false) 2nd case: set xlDriver1 = DDT.ExcelDriver(C:\Script- Resources\BatchRun\myfile2.xls,"BatchRun",True)
Why you are doing so? Try to change it to False.
rhsou123
8 years agoContributor
it was false for both drivers and just update it to check if it works.
Even with two false it is not working.