Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to load data from multiple files, but just the data in G14 cell in all the files, along with file name.
Load G,
FileBaseName()
From test.xslx
(ooxml, no label, table is Sheet) WHERE RecNo()=14
This is not working. Any suggestions???
Try it with:
first 1 Load G as Field, FileBaseName() as File From test.xslx
(ooxml, no label, header is 14 lines, table is Sheet);
- Marcus