Load specific rows from data

[berstrom]

Hey!

How can I load specific rows from an excel dataset, like for example rows 10 to 15?

Best regards

[pianoman15 · Accepted solution]

Something like this?

LOAD A
FROM
Excel.xlsx
(ooxml, no labels, table is Sheet1)
where RecNo()>=10 AND RecNo()<=15
;