DMT can consume Excel sheets also, sadly the last time I looked it can’t consume anything other than Sheet 1. Leading 0’s is a problem (apparently there is a new option in Excel to enable not truncating leading zeros)
Hmmmm. Now that would be useful to be able to DMT in parallel by loading multiple sheets at the same time… I know you can manually run the same DMT template with different data at the same time.
How does the Epicor ERP Analyzer / Cirrus program do it? Maybe there’s something that can be leveraged, or turned into a feature for us lowly customers. Ideas?