Automate load file

[Fred12]

Hello,  when I do it, it works : 

LOAD *

FROM [lib://Sharepoint /Shared Documents/Offre /04/01- azer/1.01 vetement/file1.xlsx]

(ooxml, embedded labels, table is [RENDU ]));

I got just a file xlsx in my folder (1.01 vetement)

When I try to automate, I did : 

LOAD *

FROM [lib://Sharepoint /Shared Documents/Offre /04/01- azer/1.01 vetement/*]

(ooxml, embedded labels, table is [RENDU]));

The first code works  but the 2nd code say me :

error : BadFileSize

Thanks for reading me

[Kushal_Chawda]

@Fred12  You have multiple excel files so it is possible that all your excel files don't have sheet name [RENDU ] . This could be one reason to fail. In your other open thread I have already posted solution on this issue. There could be  other files in this folder which you don't require to load which you can remove from the folder if possible or use wildcard with file name  eg. use file*.xlsx which will load file name start with file instead just '*.xlsx'. You might need to check the column names are same and it has same number of columns in required sheet.

[Fred12]

Yes I tried your solution but it returns me nothing anyway.

I have no clue about what I can do 

And in my folder, I have just 1 file xlsx.

But I have 5 sheet and I take just one of them ( "RENDU")

[Kushal_Chawda]

@Fred12  looks like you forgot to mention file format as per your pasted code

LOAD *

FROM [lib://Sharepoint /Shared Documents/Offre /04/01- azer/1.01 vetement/*.xlsx]

(ooxml, embedded labels, table is [RENDU]));