Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Store data from loads outside a loop

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;

1 Reply
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

http://robwunderlich.com