Hi,
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.
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
Bhavik_Solanki, looks like this link is not active now.
@monish06 is your issue fixed? i am also facing the same issue
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,
Hi @monish06 please do this,
connection string : “Dsn=Excel Files;dbq=“your excel file path”;driverid=1046”
provider name: “System.Data.Odbc”