yes, I guess that would be an option since the files are exported by someone here on site and so every file has only one sheet.
Alternatively, how could I check the sheet_name? That's what I was just trying to do, but I don't know any function that would do this.
Thanks a lot!
Well, in the example I linked first a table named tables is created and loaded with the data returned by the SQLtables command. Next a for-next loop is iterating through this table. In that loop you can check the sheet name you get from the tables table with a wildmatch:
LET sheetName = purgeChar(peek('TABLE_NAME', i, 'tables'), chr(39));
if(wildmatch($(sheetName), 'owssvr*') then
...load the data