Upload Excel files from a PC to the iSeries

I'm looking for the quickest and easiest way to upload Excel files from my PC to the iSeries. It's always easy...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

to download from the iSeries to PC excel files, but not the other way. The method I use to upload, which involves creating a DDS, uses Client Access data transfer to download to the PC just to get .FDF. Is there an easier way than this?

I don't think you'll find any OS/400 features that make it substantially easier. To do that, you'd probably need to buy a third-party data movement or replication product.

One approach would be using the CPYFRMIMPF CL command.

1. Define target table with DDS or SQL.
2. Export Excel file into delimited format.
3. FTP delimited format file to your iSeries server.
4. Use CPYFRMIMPF CL command to load the delimited format file into the target table.

================================== MORE INFORMATION ON THIS TOPIC ==================================

Search400.com's targeted search engine: Get relevant information on DB2/400.

The Best Web Links: tips, tutorials and more.

Check out this recent Search400.com Featured Topic: Ask the DB2 UDB doctor .

Copying IFS files with QCMDEXC as SQL stored procedure

iSeries freeware/shareware library

Run multiple SQL statements

Dynamic Screen Manager lets you build screens and windows on the fly

Please create a username to comment.

IoT data center tech aims to improve operational efficiency

An introduction to DCIM software metrics and terms

6 steps to prep your organization for ISO 9001 certification

Dig Deeper on DB2 UDB (universal databases)

Copying IFS files with QCMDEXC as SQL stored procedure

iSeries freeware/shareware library

Run multiple SQL statements

Dynamic Screen Manager lets you build screens and windows on the fly

Related Q&A from Kent Milligan

Start the conversation

0 comments

Register

Login

Forgot your password?

Your password has been sent to:

Please create a username to comment.