AS/400: Move / Convert Data from Excel Spreadsheet to DB2/400

On AS400, first create a DB file in the relevant format using either DDS or SQL

eg


CREATE TABLE QGPL/TEMPXML
(
FILE CHAR(10),
FIELD char(10),
DBFIELD char(10),
DESCRIPTION CHAR(100),
DATATYPE CHAR(20),
FORMAT CHAR(20),
SYSTEM CHAR(20));

Then save the xls as a CSV to the iSeries IFS

Once the file has been saved to the iSeries, use the following command to convert the spreadsheet to a native as400 DB2/400 file:

Use the CPYFRMIMPF command (copy from Import File). This is by far the easiest method and you're not restricted by the file name lengths, etc. Here's what the command looks like:

CPYFRMIMPF FROMSTMF('\iSeries directory\test.csv')
TOFILE(testlib/TESTF)
RCDDLM(*ALL)

Check this has imported to your as400 correctly