Excel as Database throws error


When I use excel as database, am getting following error. How can i resolve it.


1 Like

The Connect activity is used to connect to an SQL database. To read from an Excel document, use the Read Range activity.

@monish06, Can you share “Configure Connection…” detail? It seems like some component are missing in your system. Try installing following driver and it should resolve issue.



“Provider=Microsoft.ACE.OLEDB.12.0;Data Source=” & ExcelPath & “;Extended Properties=’Excel 12.0 Xml;HDR=YES;IMEX=1′;” This is my connection details.

@monish06, Have you try installing MDAC (from given link)? if not please install it and try again.

Ok bro I’ll try and let you know.

Kindly have a view in this

And may I know why we are using as a database rather we can try using excel activities

Cheers @monish06

1 Like