Loading multiple excels

[ecabanas]

Hi 

I have a folder with several excel files. I would like to import all files with the same tab to a table. I create a connection to the folder where the files are, but the script fails, any idea what's wrong?

Se ha producido el siguiente error:
Cannot open file: 'lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx;' (Native Path: ***
System error: ***)
El error se ha producido aquí:
Miservi:

LOAD Planta, 
     'PE'&TarjaPagamentNom as order_id,
     Data, 
     Hora, 
     Caixa, 
     Caixer, 
     Total, 
     LiniesTiquet, 
     Base
FROM [lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx;]
(ooxml, embedded labels, table is Capçaleres)
No se han cargado los datos. Por favor, corrija el error y pruebe a cargar de nuevo.

Thanks

[haskia · Accepted solution]

Hi @ecabanas ,

I think there's a typo in your FROM statement. Try changing it into

FROM [lib://Miservi_Excels (ulabox_ecabanas)/*.xlsx] ;

Another common error when loading from Excel spreadsheets - is different sheet naming. In that case you would need to adjust or drop this part:

table is Capçaleres

[ecabanas]

Hi @haskia 

Thank you!!!! I too tired 😉