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

On 3/2/26 1:50 PM, Glenn Gundermann wrote:
> 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.

I've got another spreadsheet, even bigger. There are only two 
significant columns in the spreadsheet (a record ID and an email 
address), but the target PF has eight more fields that I'd like to 
either ignore, or fill with literal values. I have the .fdfx file 
generated by Mr. Gundermann's step 2; can it be edited to do what I 
want? I don't see any docs on how to manually create and/or edit .fdfx 
files.

--
JHHL

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request-+hD5IHI5Xscn3HwCXmMcX9BPR1lH4CV8@public.gmane.org
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support-FMtJrHiV//lnDLsaKlm4mFaTQe2KTcn/@public.gmane.org for any subscription related questions.