Excel as Database throws error

Hi,

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

@Palaniyappan

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.

https://www.microsoft.com/en-in/download/details.aspx?id=5793

Cheers

“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
https://social.msdn.microsoft.com/Forums/Lync/en-US/62ee4978-ca29-48d3-9367-6dd4ab639d2d/could-not-find-installable-isam?forum=adodotnetdataproviders

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

Cheers @monish06

1 Like