Store data from loads outside a loop

Tue, 16 Jul 2013 22:35:38 GMT

How I can store data from loads outside a loop.

Something like this:

(create a empty table)

For each ExcelFile in filelist ('*.xlsx')

Load * (...)

(store data into the empty table created above. increasing the data)

Next ExcelFile;

Re: Store data from loads outside a loop

rwunderlich — Wed, 17 Jul 2013 01:37:05 GMT

Assuming the field list is the same, concatenation to the already created table is automatic. You don't need to do anything.

-Rob