Excel as Database throws error

[monish06 (monish)]

Hi,

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

@Palaniyappan

[Anthony_Humphries]

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

[Bhavik_Solanki]

@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

[monish06 (monish)]

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

[Bhavik_Solanki]

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

[monish06 (monish)]

Ok bro I’ll try and let you know.

[Palaniyappan (Forum Leader)]

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

[venkat4u (venkat)]

Bhavik_Solanki, looks like this link is not active now.

@monish06 is your issue fixed? i am also facing the same issue

[Gujjula_Murali]

@Palaniyappan @venkat4u

Hi, we have 500 Mb excel data, we are not able to read the data using excel and workbook activities , so we are trying to use this method but we are facing issue

“Connect to database: Could not find installable ISAM.”

If you have any idea , please let me know

Thanks
Murali,

[Tapan_Behera1 (Tapan Behera)]

Hi @monish06 please do this,

connection string : “Dsn=Excel Files;dbq=“your excel file path”;driverid=1046”

provider name: “System.Data.Odbc”