Hey Aseel,
This error usually comes when the correct drivers are not installed on your machine. I have a exe setup file for Access Database Engine, though I don't remember the exact source URL from where I downloaded it but I am sharing the drive link where I have that exe file saved: Access Database Engine InstallationDISCLAIMER : Please download at your own risk as it is not being provided or promoted by me.
Also, check if you are using the below connection string:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=<FILE_PATH>;Extended Properties="Excel 12.0;HDR=YES";
You can try replacing the highlighted text with the actual file path consisting of the file name and extension along with the full file path. For example:"C:\Test\Test.xlsx"------------------------------
----------------------------------
Hope it helps you and if it resolves you query please mark it as the best answer so that others having the same problem can track the answer easily
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Sr. Consultant - Automation Developer,
Wonderbotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website:
https://devneet.github.io/Email: devneetmohanty07@gmail.com
----------------------------------
------------------------------
----------------------------------
Hope it helps you out and if my solution resolves your query, then please provide a big thumbs up so that the others members in the community having similar problem statement can track the answer easily in future.
Regards,
Devneet Mohanty
Intelligent Process Automation Consultant | Technical Business Analyst,
WonderBotz India Pvt. Ltd.
Blue Prism Community MVP | Blue Prism 7x Certified Professional
Website: https://devneet.github.io/
Email: devneetmohanty07@gmail.com
----------------------------------