Read A Excel Spread sheet create iSreies fil

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.

Read A Excel Spread sheet create iSreies fil

Postby amsoffen » Fri Dec 06, 2013 2:28 pm

I have a Spread sheet where 1st row is the field names. I want to create a temporary file where I can read remaining data into and then copy the data mapping it into an as400 file or read the spreadsheet and insert data into a iSeries file. I am very new to go anywhere and this is the first porject I need to complete.
amsoffen
 
Posts: 1
Joined: Wed Dec 04, 2013 10:56 am

Re: Read A Excel Spread sheet create iSreies fil

Postby Support_Rick » Sun Dec 08, 2013 12:15 pm

GoAnywhere has example project templates that will help you create work flows.

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...
Rick Elliott
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 196
Joined: Tue Jul 17, 2012 2:12 pm

Re: Read A Excel Spread sheet create iSreies fil

Postby Nana111 » Wed Jan 22, 2014 1:20 am

Hi there
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
Nana111
 
Posts: 1
Joined: Mon Dec 02, 2013 2:09 am

Re: Read A Excel Spread sheet create iSreies fil

Postby Support_Chris » Fri Jan 24, 2014 9:16 am

Hi Nana111,
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.goanywheremft.com/products/d ... ranslation

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.goanywheremft.com/download and enjoy a 30 day free trial period.

Please let us know if we can help in any way.
Support_Chris
 
Posts: 6
Joined: Thu Oct 24, 2013 10:23 am


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 2 guests

cron