Unknown LOAD statement error

[EvanBarrick]

I am attempting to run the following script:

thsSALESDATA:
BUFFER (incremental) LOAD * FROM [lib://THS Aggregate (brand_mike.smith)/*.xlsx](ooxml, embedded labels, table is THS);

STORE thsSALESDATA INTO [lib://QVD (brand_mike.smith)/THSaggregate.qvd(qvd)];

There are three files in the directory from which I am loading; they all have the same number of columns and exactly the same headers. 

What could be causing this error?

[EvanBarrick]

this is how I set my script but am getting an error

set vRoot = '.';

FOR Each File in filelist ('$(The Store Name Agg (brand_mike.smith)\*.xlsx')
Temp:
LOAD *
FROM
[$(File)]
(ooxml, no labels, table is THS);
let qvdname= replace(File,'xlsx','qvd')

[dplr-rn · Accepted solution]

Sorry i missed next file line at the end and forgot it was qlik sense.

see below change lib://TestLoop to your connection string

set vRoot = 'lib://TestLoop';
FOR Each File in filelist ('$(vRoot)'&'\*.xlsx')
Temp:
LOAD *
FROM
[$(File)]
(ooxml, no labels, table is data);
let qvdname= replace(File,'xlsx','qvd');

next File

[EvanBarrick]

This loads successfully with no errors. I like this format of loading in the data than what I was trying to do. Thank you

[dplr-rn]

No problem. glad to help