Adding multiple excel files

[#1]

Ok guys, so I have a folder with many excel files. All of them start the same way.I added one of them and created a chart as I want it.Now I want to add all the other files and doing it manually is not an option. After Loading the first one,can I add the others like that ?

LOAD *

From

(biff, embedded labels, table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$]

[Anonymous]

If all the columns are the same in all of the files, then load * should work. If they have different sheet names in the excel files, just take out ", table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$]" from the last line.

[santiago_respane]

Hi Dilyan,

You can use a For to loop through files, this way when there are no files to load you wont get an error.

Something like this:

FOR Each File in filelist ('C:\Users\dilyan\Desktop\Reports\*.xls')

      LOAD *
      FROM ['$(File)'] (biff, embedded labels, table is [справка №2-ОТЧЕТ ЗА ДОХОДИТЕ$];

NEXT File;

Hope this helps.

Kind regards,

[#4]

Hi Santiago,

I don't get an error message when I execute it the  way you mention but I don't have my fields anymore available. I only have ....