If you need to split up an Excel file into separate workbooks, then it can be time-consuming and error-prone to do this manually.
Using Loadit it’s easy to create a package to load the Excel file, split the data into separate datasets and write each dataset into a separate file.
This video shows this in action and the steps required to create a Loadit package to automate this process.