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