How to migrate Microsoft excel data to MS SQL database in MII 12.0

In one of our requirements,we needed to migrate huge data from Microsoft excel to MS SQL database.One single excel sheet data needed to insert to many tables of MS SQL.

Subject Knowledge:

Microsoft excel and MS SQL.

Creating a Microsoft Excel SAP xMII UDS Instance.

Creating an Excel SAP xMII UDS Instance from SAP MII.

Transaction flow.

Technical Requirement:

Requirement is to migrate data from Microsoft excel sheet to MS SQL data base. One excel sheet data to be migrated to more than one tables of SQL. Here I would like to illustrate this with a small example.Suppose there are three rows and many columns in the excel which will be migrated to two tables.

This section gives step by step approach on how to do data migration from Microsoft excel to MS SQL database in MII.

Approach:

Here are the Steps:

Step 1: Working on Microsoft Excel

1. Select all the rows and do unhide by right click on the excel. Select all the columns and do unhide.