Expression

[#1]

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

[Michiel_QV_Fan]

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$);

[#3]

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;