as400 to excel

Tags:
Exporting AS/400 to Excel
how to move the control from as400 to excel and copy the data from excel again move to as400

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 addins from there.

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

<a href=”http://www.as400tutorials.com/as400-to-excel/”>AS400 to Excel</a>

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • 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.
    6,435 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
    195 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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following