Skip to Content
0
Former Member
Aug 18, 2015 at 01:54 PM

Excel Integration with SAP MII Using PCO 2.3

610 Views


Hi Experts,

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

Attachments

Capture.PNG (46.0 kB)
Capture1.PNG (130.1 kB)
Capture3.PNG (158.3 kB)
Capture4.PNG (103.6 kB)
Capture5.PNG (118.3 kB)
Capture 6.PNG (73.4 kB)