When you create a project, click on the browse button (the button with 2 dots at the end of the prompt). Then, pick a project that closely resembles what the job is you need.
In this case, pick the "FTP Get Encrypted Excel to Database". You can remove the Decryption Task and/or the FTP|Get. This leaves you with the ReadExcel and the Connect to DB tasks which will help you do what you need. Just modify to point to your resources and/or file names and you should be good to go.
Please let us know if we can help any further...
Lead Solutions Consultant
I have encountered the same questions.I am new here and i want to read the excel spreadsheet and insert data into a iSeries file.I have tried to do that using this Excel program:
http://www.rasteredge.com/how-to/csharp ... l-reading/
But it can not work effecive.I want to know that if there is a tool which supports to do that directly.
Thanks a lot
I have good news for you then, GoAnywhere Director can translate your data from an excel spreadsheet to an iSeries file. In fact, if you'd like to read more about the different types of formats that GoAnywhere Director can read and write, here is a direct link: http://www.goanywhere.com/products/director/translation
The steps that Support_Rick laid out in his prior post would work nicely for your request.
If you'd like to give GoAnywhere Director a try, you can download the product from here, http://www.goanywhere.com/download and enjoy a 30 day free trial period.
Please let us know if we can help in any way.
Technical Support Manager
w. GoAnywhere.com | HelpSystems.com