Re: [External] Regarding downloading data from IBM i series

[jerry ven <jerryven95@xxxxxxxxx>]

I tried these different options but getting junk data in excel file also
getting error 'CWBTF0009 - The Data in this Field Is Too Long for the
OS/400 Field'

Thanks

On Tue, 7 Jun 2022 at 19:59, Lehti, Eric <elehti@xxxxxxxxxxxx> wrote:

> Jerry,
> Those options are available so you can get the results you want for the
> excel format you choose.
>
> -----Original Message-----
> From: RPG400-L <rpg400-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of jerry
> ven
> Sent: Tuesday, June 7, 2022 9:20 AM
> To: RPG programming on IBM i <rpg400-l@xxxxxxxxxxxxxxxxxx>
> Subject: [External] Regarding downloading data from IBM i series
>
> [WARNING]: External Email
>
> Hi,
>
> When trying to download a spool file's data which is in a flat file
> (copied spool file into a flat file) in IBM i  to local desktop in a excel
> file format  then which specific settings under file details like BIFF3(MS
> Excel3 - 8) should be selected to download this spool file in a good excel
> format to local desktop?
>
> also under PC file description file how hould it be saved 1 enhanced or 2)
> standard
>
>
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com