loading different excel files at a time

[Anonymous]

hi all,

i have different excel files with different names .so how to load all these files at a time .

Thanks

[its_anandrjs]

Hi,

There are many ways for this try this ways

Load multiple sheets and excel files

Load Multiple excel sheets using For loop

LOAD *

FROM

(ooxml, no labels, table is sheet1);

Or

LOAD *

FROM *.xlsx
(ooxml, embedded labels, table is [$(*)]);

Regards

Anand

[Anonymous]

hi  first of all thanks for your reply , i have another doubt if we have different file formats like .txt, xlsx etc then  how to load  ?

[its_anandrjs]

Hi,

If you can read this post it provides info for the multiple file loading

Re: loop through to load all files from a folder and its subfolders?

Regards

Anand