Hi,
Is it possible to load data into 2 tables from a single data file having multiple headers (One header data and multiple line data)?
Data FIle :
File Number,,,,,,
1,,,,,,
,,,,,,
Data1,Data2,Data3,Data4,Data5,Data6,Data7
100,Test 1,XXX,Test 1,100,XXX,Test 1
101,Test 2,FFG,Test 2,101,FFG,Test 2
102,Test 3,GJH,Test 3,102,GJH,Test 3
103,Test 4,HDUD,Test 4,103,HDUD,Test 4
104,Test 5,GDD,Test 5,104,GDD,Test 5
105,Test 6,DJDD,Test 6,105,DJDD,Test 6
106,Test 7,OSJD,Test 7,106,OSJD,Test 7
107,Test 8,ODDD,Test 8,107,ODDD,Test 8
the value in the file number column should go to a table and the va;ues in the data columns will be in another table.
Regards,
Bharat.