?

[xyz1]

.

[tresB]

You could probably increase/decrease the Header size to browse to different table in the same sheet.

[xyz1]

.

[tresB]

If this is a static data source you could put a condition for upper tables to tell how far (may be row count) to fetch the data for that specific table. May be like:

Load

          *

From [lib://....] Where RecNo()<100;

Or you may put a flag in between to check to put a break in the load.

[xyz1]

.

[tresB]

No. I meant to insert a static value for your fist column. But that would not be an easier option I realize. So better stick with the row count method if that solves your purpose.

[xyz1]

.

[tresB]

Yes, without that brackets for where clause, like

FROM [lib://Trend/Trend.xlsm] Where RecNo()<12 ;

Isn't it working?

[xyz1]

.

[tresB · Accepted solution]

This is working for me:

LOAD

    "Month",

    "Forecast CAPEX",

    "Forecast GFC",

    "Initial CAPEX",

    "Initial GFC"

FROM [lib://aaa/trash.xlsx]

(ooxml, embedded labels, header is 16 lines, table is Sheet1) where RecNo()<13;