Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I'm trying to load multiple Excel sheets from 1 file, using the FOR loop.
But got a mistake when implemeting it:
FOR Each sheet in 'Sheet 1', 'Sheet 2' [Test]: LOAD F1 as ValueType, F2 as Brand FROM [Excel.xls] (biff, embedded labels, header is 4 lines, table sheet) NEXT
I think the problem is in sheet naming there -
(biff, embedded labels, header is 4 lines, table sheet)
Any suggestions please?
Thanks,
I've tried but got error Cannot locate table in BIFF file