Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to load file with the same name from different folders
I thought I could write:
S:\ds\GTT\*\Exporttabell.xls
the folders are for example:
S:\ds\GTT\one\Exporttabell.xls
S:\ds\GTT\two\Exporttabell.xls
S:\ds\GTT\three\Exporttabell.xls
How can I manage to solve this?
I think you can use * (0 or n char) and ? (one char) symbols in your load instruction :
1) first build your load instruction on one file (using wizard if needed),
2) replace the folder name by *
LOAD F1,
F2
FROM
(biff, embedded labels, table is Feuil1$);
hopes it helps
best regards