Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
let me explain : I have 12 excel sheets by month name 02-01-2014 to 02-12-2014 .
I want to know what expression do i need to write in the edit script so that i can fetch all the 12 excel sheets . I dont want to load individual ecel sheet from table view. I hope iam clear
Thanks in Advance.
kane
If they are in 1 Excel work book, thus12 tabs, just remove the sheet from the load statement
(biff, no labels, table is Ritten$); will be (biff, no labels);
If you have 12 different work books replace the name of the work books in the load with a * (wildcard). Then all 12 are loaded.
FROM
(biff, no labels, table is Ritten$);
Hi,
You can use a loop to process all sheets in the file. Like this:
for index = 1 to 12
let TableName='02-'&Num(index,'00')&'-2014';
MyTable:
LOAD *
FROM
[MyFileName.xlsx]
(ooxml, no labels, table is $(TableName));
next index;