RE: XL -> 400

I think V5R1 has the option is iSeries navigator that I use for this
purpose. Open a Data Transfer to iSeries, select Tools, then Create
iSeries Database File, click next, select the XL file you want to
upload, click next, select the file type (BIFF8 or BIFF5/BIFF7), click
next, accept the default on the Create File description file screen and
click next, click next on the change data options, select First row of
data contains field names if the file does(after making sure they are
all valid iSeries variable names), then click on Start Scan, click next
, click next, click next, enter the iSeries Library and file name then
click next, enter a description if desired, click next, click next,
click finish, then click transfer to iSeries. This will create a new
table on the iSeries with your XL data in it.

If this feature does not exist in V5R1, there are other options but this
is the easiest I know of.

John Arnold
(301) 354-2939

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Al Mac Wheel
Sent: Friday, October 10, 2008 12:29 PM
To: Midrange-L
Subject: XL -> 400

We're on AS/400 Model 170 with V5R1, due to BPCS cost-prohibitive to
upgrade, and I'm limited to native/400 & maybe shareware if I can get it

uploaded.
I got an Excel from another company.
We want to import some columns to a PF/400, to eventually match similar
data.

What alternate ways are available to accomplish that?
FTP CA IFS
Ops Nav in reverse
Can I SEU/PDM a cut & paste into a PF?
Where's those ways how-to documented?

You could point me to a recent thread I did not pay attention to at the
time.

I would also like a technique that is easy for use by non-technical
co-workers & safe.
I don't want a co-worker inputting such a file to overlay good stuff.
-
Al Macintyre