Hi experts,
Please help me to load data in multiple sheets of same excel work book. what should be the modification for my script?
I have 15 excel work sheets in my work book "LOAN_RECOVERY.xls" named as "RL0001/RL0002.............RL0015"
My simple script is as follows.
LOAD PRD_COD,
VALUE,
INS_AMT,
NO_INS
FROM
E:\REED\PRD_MASTR.xls
(biff, embedded labels, table is Sheet1$);
LOAD DATE,
LOAN_NO,
PRD_COD,
NAME,
LOAN_AMOUNT
FROM
E:\REED\LOAN_REG.xls
(biff, embedded labels, table is Sheet1$);
LOAD
REC_DATE,
MONTH(REC_DATE) AS MONTH,
YEAR(REC_DATE) AS YEAR,
LOAN_NO,
NO_OF_INS,
//NAME,
LOAN_AMT,
LOAN_OBAL,
INS.NO,
COLL_CODE,
RECEIPT_NO,
INTERST,
CAPITAL,
RECEIPT_AMT,
LOAN_CBAL,
DEFALTS,
REMARKS,
F16
FROM
E:\REED\LOAN_RECOVERY.xls
(biff, embedded labels, table is RL0001$);
