RE: format 'prn' to ACCESS

[murali dhar <hydchap1@xxxxxxxxx>]

Sincerly thank  Pete,Mark,Vern,rob,michael for your
great inputs, I have started working in right track.
Thanks once again
Murali.
--- Pete Helgren <pete@xxxxxxxxxx> wrote:
> Murali,
> 
> Based on the responses thus far, you can probably
> see that a "direct
> conversion" to Access is NOT possible.  However,
> several good techniques
> have been recommended.  I think there was an earlier
> article reference or
> post about using cpytoimpf then importing to Access.
>  There are plenty of
> references to those techniques.
> 
> Depending upon your Java skills, there was a
> relatively recent post about an
> Open Source project called OS400Bridge (you'll find
> it on sourceforge.net
> (very cool)).  With bit of tweaking, you could
> modify the example to write
> directly to the Access database with no need for
> creating a file in the IFS,
> FTP'ing and then converting.
> 
> All viable solutions providing you have the skills
> to apply them.
> 
> Pete Helgren
> 
> 
> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> murali dhar
> Sent: Thursday, February 26, 2004 10:14 AM
> To: Midrange Systems Technical Discussion
> Subject: format 'prn' to ACCESS
> 
> 
> Dear all,
> 
> Iam sending a file to downstreams by FTP with
> following cmd.
> PUT qs36f/ysmam001.ysmam001 am001.$DATE$.prn
> (as per earlier request by Downstreams 'prn' format
> was mentioned since it accomodates certain
> requirments.)
> 
> Now they want the information into ACCESS.
> 
> is it be possible to send  the file in an Access
> Database format instead? and how?
> 
> Thank you for your help in adv,
> Thank you for your patience,
> Murali.
> 
> __________________________________
> Do you Yahoo!?
> Get better spam protection with Yahoo! Mail.
> http://antispam.yahoo.com/tools
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion
> (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit:
>
http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the
> archives
> at http://archive.midrange.com/midrange-l.
> 


__________________________________
Do you Yahoo!?
Get better spam protection with Yahoo! Mail.
http://antispam.yahoo.com/tools