Forum Discussion

AngBet1's avatar
AngBet1
New Contributor
10 years ago

DDT.ADO Driver issue

Im trying to execute the below lines of code  and Im ending up with "Provider  cannot be found.It may not be properly installed" error. I've installed Microsoft DataBase Access Engine 2007. Not sure what the problem is.Can someone please help with this??

 

Constr=//Connection string is defined
var SQLStatement ="select * from tablename";
var res = DDT.ADODriver(Constr, SQLStatement);

 

 

1 Reply

  • TanyaYatskovska's avatar
    TanyaYatskovska
    Icon for Alumni rankAlumni
    10 years ago

    Hi Angbet1,

     

     

    You need to use the Microsoft DataBase Access Engine 2007 provider to work with Excel files. As you are trying to get access to SQL, Microsoft OLE DB Provider should be installed.