Move control from AS/400 to Excel

5 pts.
Tags:
AS/400 import/export
How to move the control from AS/400 to Excel and copy the data from Excel again move to AS/400?
Asked: Last updated:
Related Questions
1

Answer Wiki

Thanks. We'll let you know when a new response is added.

In Client Access you can set up the data transfer from and to an iSeries server. You can manage your add-ins from there.

Here is a really quick but step by step method to get data from your 400, iSeries or system i into Excel:

AS/400 to Excel

Long story short there are many ways to skin this cat

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Littlepd
    Sounds like you want to initiate an upload from Excel to DB2 on the i. To do this, look into Excel VBA programming, and ADO.
    1,130 pointsBadges:
    report
  • WoodEngineer
    If you are using the Client Access add-ins for Excel, it is possible to send data from an Excel spreadsheet to the AS/400 and let the system automatically create a file to receive the data. The field names are very generic but it works. This is the simplest way to handle such transfers. If the job needs to run in a production environment, you will probably want a more controlled transfer of data.
    8,235 pointsBadges:
    report
  • John Andersen
    Here is a really quick but step by step method to get data from your 400, iSeries or system i into Excel: AS400 to Excel -JA
    205 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: