Reading Excel file With Headers & Details on different tabs (3 replies)
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.
I am trying to import a excel file with two tabs – one header records, the other detail records.
Is this possible?