Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Yes, check out Mayuresh_d's response:
for each vFile in FileList('..\*.xlsx')
TableName:
load
'$(vFile)' as SourceFile,
FileDir() as Dir,
FileName() as File_Name
from [$(vFile)]
(ooxml, embedded labels, table is Sheet1);
STORE Table Into 'D:\EDMS\'$(vFileName)'.qvd';
Drop table TableName;