File Transfer
How do I transfer a Excel Spreadsheet to the AS400?
Thank you
Marymartha
Software/Hardware used:
Software/Hardware used:
ASKED:
August 5, 2005 8:35 AM
UPDATED:
February 15, 2006 12:42 AM
RELATED QUESTIONS
Answer Wiki:
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
To see all answers submitted to the Answer Wiki: View Answer History.
Through a CL program, how can I get the Excel files in IFS folder to AS400 database table?
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