Re: AS400 to EXCEL

["Pete Clifford" <Pete@xxxxxxxxxxxxxxxxxx>]

You might also like to check out @riadne's Slipstream product
(www.ariadnesoftware.co.uk). This converts iSeries database files to native
Excel format (two flavors of Excel available), as well as CSV, other
delimited formats and fixed text. You can also run a query or piece of SQL
and save the output directly as a spreadsheet. The option to email the
output will be available in the next couple of months.

End of commercial. I'll stick to RPG questions now....

Pete
<MEovino@xxxxxxxxxxxxxxxxx> wrote in message
news:OF6B8B69FE.561ABB3F-ON85256D25.00732B08-85256D25.0073B6D8@xxxxxx
>
> Since people are asking about Excel to DB2, Kemetech has a product for
this
> as well.  We have bought it, but no one has really used it yet, so I can't
> comment.
>
> Mike E.
>
>
>
>
>
>                     "Mike Haston **
>                     Data"                     To:     "RPG programming on
the AS400 / iSeries"
>                     <MHaston@xxxxxxx>
<rpg400-l@xxxxxxxxxxxx>
>                     Sent by:                  cc:
>                     rpg400-l-bounces@xx
Subject:     RE: AS400 to EXCEL
>                     drange.com
>
>
>                     05/13/2003 04:36 PM

>                     Please respond to
>                     RPG programming on
>                     the AS400 / iSeries
>
>
>
>
>
>
> I used to use CPYTOPCD and send it over as a .prn file and that could be
> messy with what you are talking about.  Not to mention it required the
> users to think briefly when using the import wizard in Excel!
>
> CPYTOIMPF has worked very easily for me *so far*.  Like Bob said, open it
> in Excel, no wizard or anything and save it as your .xls file.
>
>
> -----Original Message-----
> From: rob@xxxxxxxxx [mailto:rob@xxxxxxxxx]
> Sent: Tuesday, May 13, 2003 3:53 PM
> To: RPG programming on the AS400 / iSeries
> Subject: RE: AS400 to EXCEL
>
>
> And the reply that comes up on that all the time is if you have a string
> field that just happens to be all numeric, it makes it numeric.  Or some
> such argument.  I think that's in the archives also.  I just remember
> something like that.
>
> Rob Berendt
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>
>
>
>
> _______________________________________________
> This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/rpg400-l.
>
>