I have an excel template called an estimate to complete (ETC) template, where consultants fill in the number of hours per month they believe it will take to complete an engagement. We have a batch scheduler that populates about 100 ETC templates per MD to fill out and they are posted to SharePoint. Once all of the files have been completed by the MDs and saved to SharePoint, we want to import the data into JDM. What is the best way/resource to take all of the excel files and get the hours by month data in each template into a single data source in JDM?
Moving numerous excel files into JDM