Hi mani,
Try as follow:
load your file directly without changing a thing, then change all the load statement as follow:
LOAD
F1 as "Operation Cod",
F2 as "Operation Description",
No. as "Santro No",
Tax as "Santro Tax",
Amt as "Santro amt",
"Tot Amt(tax+amt)",
No.1 as Getz,
Tax1,
Amt1,
"Tot Amt(tax+amt)1",
No.2 as Accent,
Tax2,
Amt2,
"Tot Amt(tax+amt)2",
No.3 as Elantra,
Tax3,
Amt3,
"Tot Amt(tax+amt)3",
No.4 as "NF-Sonata",
Tax4,
Amt4,
"Tot Amt(tax+amt)4",
No.5 as "EF-Sonata",
Tax5,
Amt5,
"Tot Amt(tax+amt)5",
No.6 as Tucsan,
Tax6,
Amt6,
"Tot Amt(tax+amt)6",
No.7 as Terracam,
Tax7,
Amt7,
"Tot Amt(tax+amt)7",
No.8 as i10,
Tax8,
Amt8,
"Tot Amt(tax+amt)8",
"No" as i20,
Amt9,
Tax9,
"Tot Amt(tax+amt)9",
No.9 as Verna,
Tax10,
Amt10,
"Tot Amt(tax+amt)10",
No.10 as Other,
Tax11,
Amt11,
"Tot Amt(tax+amt)11",
No.11,
Tax12,
Amt12,
"Tot Amt(tax+amt)12" as "TOTAL"
FROM [lib://source/S.A WISE.xls]
(biff, embedded labels, header is 1 lines, table is Rajiv$);
Don't forget to make header is 1 lines like in the line above !
