Skip to Content
avatar image
Former Member

Picking Excel sheet data from a shared drive

Hi Experts,

I am using using SAP  MII version 14.0 SP5 Patch 5.

I want to connect SAP MII to Microsoft Excel to get the Excel sheet data putting some Conditions in BLS  and saving data into Oracle database.

Actually my requirement is to pick  Excel sheet data from a shared drive and putting some logic in BLS and saving data in Oracle Database.

Can you please help me that how to Pick the Excel sheet from a Shared Drive.

Regards,

Ajit Kumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 09, 2014 at 10:19 AM

    Hi Ajit,

    You can create an OLEDB dataserver to connect to the excel. You can refer below link for connection strings:

    Excel connection strings - ConnectionStrings.com

    Warm Regards,

    Swaroop

    Add comment
    10|10000 characters needed characters exceeded