Skip to Content
0
Former Member
Nov 07, 2007 at 05:07 AM

Upload data from Excel to Itab

18 Views

Dear All,

Suppose I have data in the form of a matrix and I need to upload the data into the database after validation. The excel sheet is of the format:

Emp Empdept E1 E2 E3 E4 E5 E6 E7 E8 E9

E1 MEC 0 2 3 4 5 6 6 5 7

E2 ELE 4 0 5 5 6 2 2 1 3

E3 ELE 4 4 0 6 1 4 7 8 9

E4 ECE 2 2 4 0 6 7 5 9 4

E5 CHE 7 8 9 5 0 5 6 1 3

E6 ELE 8 9 10 12 11 0 5 6 4

E7 MEC 4 5 4 6 7 6 0 5 7

E8 MEC 9 4 7 5 2 2 8 0 1

E9 ELE 1 5 2 4 2 6 4 6 0

The first column is the employee number

The second column is the employee department and

The matrix indicates the time taken by emplyee1 to be trained to handle position of employee E2 is 2 months (map using row of E1 and column of E2).

Similarly E9 to E8 is 6 months.

I have to get the above data into an internal table of the format

Emp_from Emp_to Duration

E1 E1 0

E1 E2 2

E1 E3 3

E1 E4 4

E1 E5 5

E1 E6 6

E1 E7 6

E1 E8 5

E1 E9 7

E2 E1 4

E2 E2 0

E2 E3 5

Points wil be rewarded.

Regards,

Shiva.