I have daily xls file in a folder with the names as 01-06-2016.xls,02-06-2016.xls,03-06-2016.xls,....30-06-2016.xls.
How to load them dynamically?
Thanks in advance.
SampleData is attached.
LOAD [Serial Number],
date(floor(Date#([Date & Time],'DD-MM-YYYY hh:mm:ss')),'DD-MM-YYYY') as [Date & Time],
[Vehicle Reg. #],
(biff, embedded labels, table is Sheet1$);
Change this code:
.... to this code:
Alternatively, you could go with this code:
... if you have other xls files in that folder you do not want to load.
View solution in original post