I have 14 files that must be imported in sequence so how would you suggest I best use job schedules? Depending on speed, it is difficult to gauge what time to put all these imports at. I don’t want to put them too far apart as well because then it could take a few hours to update all the data.
It depends the size of the each imported file and the linking relationship between the sheets you import to. I would suggest creating a support ticket and share the details of the files you would like to import. For example:
File Name: A
Destination Sheet: Sheet A
Destination Field: Field A and Field B