RE: data transfer

On your Client, one of the menu items is OLE, choose the option to copy the 
reports or inquiries directly to MS Excel or any other OLE compatibles.  But 
you should be a GUI user to do this.

Currently I am not working on BPCS to give you the exact menu path.  I have 
used it and it works.

Regards,

Hanumantha Rao

>
>How do I use the BPCS client OLE function?
>
>-----Original Message-----
>From: HANUMANTHA RAO [mailto:vvshrao@hotmail.com]
>Sent: 17 November 1999 04:39
>To: BPCS-L@midrange.com
>Subject: RE: data transfer
>
>
>If you are a BPCS V6.0+ user, you can straight away  transfer BPCS reports
>to Excel using BPCS client OLE functions.  Otherwise, to my experience DIF
>is the best.
>
>Regards,
>
>Hanumantha Rao
>
> >DO NOT SELECT BIFFxx IF YOU WANT YOUR DATE TO TRANSFER CORRECTLY.  USE 
>TEST
> >!!!
> >
> >
> >----- Original Message -----
> >From: Dwight Slessman <dslessman@nationalelectrical.com>
> >To: <BPCS-L@midrange.com>
> >Sent: Tuesday, November 16, 1999 9:00 AM
> >Subject: RE: data transfer
> >
> >
> > > On the PC file section, select to download an Excel type of file (one 
>of
> > > the "BIFx's")  This is under the details section where the PC file is
> > > defined.
> > >
> > > Regards and goodluck,
> > >
> > > Dwight Slessman
> > > National Electrical Carbon Products, Inc.
> > >
> > >
> > > -----Original Message-----
> > > From: Kenneally, Veronica [JNJIE] [SMTP:VKenneal@JNJIE.JNJ.COM]
> > > Sent: Tuesday, November 16, 1999 6:23 AM
> > > To: 'BPCS-L@midrange.com'
> > > Subject: data transfer
> > >
> > > Hello All
> > >
> > > Could anyone please advise on how I transfer data down to excel from 
>the
> > > AS4oo using the data transfer option in client access but transferring
> >it
> > > down in the correct format.
> > >
> > > ie if the as400 file has 4 fields I want the downloaded file to come
> >down
> > > with 4 fields rather than just throwing all the data into the first
> >field.
> > >
> > > Please advise
> > >
> > > Veronica
> > >
> > > Veronica Kenneally
> > > Business support Analyst
> > > Johnson& Johnson
> > > Belgard Road
> > > Dublin D24
> > > PH 00353 1 4510544
> > > Fax 00353 1 4510204
> > > vkenneal@jnjie.jnj.com <mailto:vkenneal@jnjie.jnj.com>
> > >
> > >
> > >
> > > +---
> > > | This is the BPCS Users Mailing List!
> > > | To submit a new message, send your mail to BPCS-L@midrange.com.
> > > | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to 
>BPCS-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list owner: dasmussen@aol.com
> > > +---
> > > +---
> > > | This is the BPCS Users Mailing List!
> > > | To submit a new message, send your mail to BPCS-L@midrange.com.
> > > | To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> > > | To unsubscribe from this list send email to 
>BPCS-L-UNSUB@midrange.com.
> > > | Questions should be directed to the list owner: dasmussen@aol.com
> > > +---
> >
> >+---
> >| This is the BPCS Users Mailing List!
> >| To submit a new message, send your mail to BPCS-L@midrange.com.
> >| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner: dasmussen@aol.com
> >+---
> >+---
> >| This is the BPCS Users Mailing List!
> >| To submit a new message, send your mail to BPCS-L@midrange.com.
> >| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
> >| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
> >| Questions should be directed to the list owner: dasmussen@aol.com
> >+---
>
>______________________________________________________
>Get Your Private, Free Email at http://www.hotmail.com
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---
>+---
>| This is the BPCS Users Mailing List!
>| To submit a new message, send your mail to BPCS-L@midrange.com.
>| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
>| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
>| Questions should be directed to the list owner: dasmussen@aol.com
>+---

______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---