I am trying to use Excel as a Database in Automation Anywhere 10. Following is my code
Connect to "Provider=Microsoft.ACE.OLEDB.16.0",Data Source = C:\Users\myuser\Documents\demo.xlsx;Extended Properties="Excel 10.0 Xml;HDR=YES";"Session:"session1"
Execute SQL statement:'Select * from [Sheet1]$'
But it is showing the following error,
Provider cannot be found. It may not properly installed.
Can anyone help with this?