UPLOAD EXCEL DATA IN dictionary TABLE

[Former Member]

I need to develop a standard program to upload various excel sheets in a dictionary table.

Structure of dictonary table is fixed.

COL1 Finished product name say: A

COL2 component NAME

COL3 SERIAL NUMBER of A

COL4 Serial number of component,

Structure of excel Sheet

First col header will be finished product header :A

first col data will be serial nos of A

Rest all col headers will be component names

Rest all col data will be component serial nos.

Info. 1. The number of components can be variable for any finished product, so that mean my excel sheets will have different number of columns every time.

Please help how should I go about it.

[Former Member]

X