Re: Got an XLS spreadsheet. Need a DB2/400 file.....

[Bryan Dietz <bdietz400@xxxxxxxxx>]

for the option 22. definatly going to give it a try, but it reminded me 
of a similar tool I found a few years ago.
https://builtonpower.com/2022/12/export-source-code-to-ifs/

Bryan


Michael Mayer via MIDRANGE-L wrote on 3/4/2026 8:02 AM:
> Morning all.
> All of the responses to James question are exactly what I expected to see.
>
> May I add another option .....
> If you have the latest version of the QMGTOOLKIT installed (Build V2026-02-25), there are new options on it for this. As most if not all of you know, the MG TOOLKIT is 1 of the IBM i's best free software.
>
> - addlible qmgtools
> - go mg
> - option 9: misc tools
> - option 13: qmgtools commands
>
> Page down. Options 19-22 are new in this build.
> Option 21.  CSVTODB2 - Convert CSV to DB2 File.
>
> MISC_CMD                      QMGTOOLS Commands
> Select one of the following:
>      15.  CPYSAV2IFS - copy a save file to IFS
>      16.  RUNFTPSCR - creates and runs an FTP script
>      17.  ZIPDIR - zip a directory
>      18.  ZIPFILE - zip a file
>      19.  PRTJOBLOGS - Print Joblogs to IFS
>      20.  CRTSQLFILE - CREATE CSV FILE FROM SQL
>      21.  CSVTODB2 - Convert CSV to DB2 File
>      22.  CPYSRC2IFS - Copy Source Physical File to IFS
>
>
> The MGTOOLKIT can be found on my blog - https://ibmireference.blogspot.com.
> Navigate to the "Helpful Tips by Category" page.
>
> Links to the MGTOOLKIT are listed.
>
>
> Respectfully,
> Michael Mayer
> IBM i on Power System Admin
> INFOR Junior LN ERP Administrator
> IBM 2024/2025 Advocate, Contributor, Influencer and IBM i Ready Badges.
>   
>
>
>
> Today's Topics:
>
>     1. Got an XLS spreadsheet. Need a DB2/400 file. What's the
>        easiest way to get from one to the other?
>        (James H. H. Lampert via MIDRANGE-L)
>     
> ----------------------------------------------------------------------
>
> message: 1
> date: Mon, 2 Mar 2026 12:45:55 -0800
> from: "James H. H. Lampert via MIDRANGE-L"
> 	<midrange-l@xxxxxxxxxxxxxxxxxx>
> subject: Got an XLS spreadsheet. Need a DB2/400 file. What's the
> 	easiest way to get from one to the other?
>
> 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
>
>
> ------------------------------