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

data upload from xls to internal table

17 Views

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

can someone help me in building the logic for this

regards,

seenu