Re: Got an XLS spreadsheet. Need a DB2/400 file. What's the easiest way to get from one to the other?

[Glenn Gundermann <glenn.gundermann@xxxxxxxxx>]

The way I upload Excel files is as follows:

1. I define a table on the IBM i. I add 1 dummy row of data.
2. Using ACS, I create a download request to download the data from the IBM
i to Excel, and create the File Definition File.
3. Using ACS, I create an upload request to upload the Excel file to the
IBM i using the FDF.

Yours truly,

Glenn Gundermann
Email: glenn.gundermann@xxxxxxxxx
Cell: (416) 317-3144




On Mon, 2 Mar 2026 at 15:46, James H. H. Lampert via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> I've got this honking big XLS spreadsheet (over 20k rows), and I need to
> replicate it as a database file. Can anybody suggest a "path of least
> resistance" for this?
>
> I have a vague recollection of doing something like this before, but I
> don't recall how. Maybe something involving CPYFRMSTMF?
>
> --
> JHHL
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.