Good afternoon,
I am trying to get connected with an XLS and XLSX file via Ole DB provider 12.0 and 16.0, from A360 I am using these connection strings for each test
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\EDI_Backup_mails\AMR_BKP_PATHS.xlsx;Extended Properties=Excel 12.0 Xml;HDR=YES;
or
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=E:\EDI_Backup_mails\AMR_BKP_PATHS.xls;Extended Properties=Excel 8.0;HDR=YES;
And getting the error mentioned,
While, if I do it via a *.udl file input the same parameters and test it I have no problems and the connection is ok, but not via task…, Have I to check any other parameter ?
Thks
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/c85a9dd4-26a9-4711-b711-9afc1de97330.jpg)
![](https://uploads-us-west-2.insided.com/automationanywhere-en/attachment/a418dee9-4f9b-4c9d-a16a-5b383b8158d7.jpg)