I am trying to find a way to append all of the Excel files in a given directory to a file on our AS/400. I can do them one at a time, but it's a time consuming process to have to go through. Is there a way to use the Data Transfer tool and pass it a range of files? I know I can create a batch to execute multiple Data Transfers, but they still need the file name hard coded. Any ideas?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!