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?
April 21, 2011 1:45 PM
May 2, 2011 10:56 PM