File Transfer

pts.
Tags:
ERP
How do I transfer a Excel Spreadsheet to the AS400? Thank you Marymartha

Answer Wiki

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

If you are using Client Access then an Add-In is provided (but must be registered) to upload directly to your iSeries through Excel.
To check if it is registered in Excel check Tools->Add-Ins. This will display a window with all installed Add-Ins. Make sure that Client Access Data Transfer is checked. If it is not in the list click the Browse button and navigate to the Program FilesIBMClient AccessShared folder and select cwbtfxla.xll.
When registered two new button should appear on your toolbar to send/receive data to/from the iSeries. These transfers may also be run through the menu by selecting the Data menu option in Excel.

Hope this helps,

Rob

Discuss This Question: 2  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
  • RamvishakRamesh
    Through a CL program, how can I get the Excel files in IFS folder to AS400 database table?
    2,505 pointsBadges:
    report
  • TomLiotta
    Through a CL program, how can I get the Excel files in IFS folder to AS400 database table?   There is no method of using only CL to convert values in an Excel file into rows/columns in a database table.   However, you should clarify if you really mean an "Excel file", or if you actually mean something like a .CSV file. A .CSV file isn't an Excel file, although Excel can read and write .CSV files for importing and exporting. Many programs can read and write .CSV files because they are intended as a simple format that is easy to handle.   I suggest you open a new question and fully describe the file(s) that you need to process.   It's also very likely that the subject of your question has already been covered multiple times on this site. Did you do any significant searching? You might have searched for [excel] and [as400] in order to find this question, but a little more detail should get you much closer.   Tom
    125,585 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