Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have multiple excel files that are the exact same, columns and headings all the same and same order.
All files only have one sheet but the sheet name is different.
Below is my script I am trying to get to work, it works with a text file but not excel.
What am I doing wrong?
LOAD
OrderDate,
OrderNumber,
FacilityName,
FacilityID,
RouteNumber,
ScheduledLeaveTime,
ActualLeaveTime
FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]
(ooxml, embedded labels, table is
assuming the table is on the first sheet in the file
this will work for you
FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]
(ooxml, embedded labels);
assuming the table is on the first sheet in the file
this will work for you
FROM [lib://HealthEX (pharmore_rwinkel)/*.xlsx]
(ooxml, embedded labels);