Frans, unfortunately it is not possible to do this.

All data must be located on a single tab.

For a guide on how to setup a hierarchical datasource, please use the following:

http://www.realisable.co.uk/support/documentation/Sage300Training/Day2.htm

(This is CSV, but the concept is identical if you are using Excel)

Thanks

Hi Frans,

The current excel reader will only read from one worksheet. You can pre-process this file in IMan to write out to a single worksheet and the read in again.

Closed due to inactivity.