RE: data transfer

["HANUMANTHA RAO" <vvshrao@xxxxxxxxxxx>]

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
+---