Requirement: Need to read Excel(.xlsx) file into SAP MII using SAP PCO 2.3 or any other recommended version, SAP MII 12.2 is the platform.
I created the following Source configurations:
In the connection string, following settings done:
I am using the above selected Provider for ODBC Drivers, as I was not able to read and test the connection succefully with Jet 4.0 Provider, further configurations done as:
My Actual Requirement is to read .xlsx but could not find it in the above list, so just tried with .xls :
Now I am able to read the Excel File, and test connection successfully:
Although Connection succeeds, I am not able to succesfully create an agent against it and run it, I get the error in log as:
Could you please let me know your valuable suggestions, how to proceed further.
Thanks in Advance