Re: data transfer

Dwight, thanks for correcting the TYPO.

TEXT format will give you the ability to design your column types (e.g..
text,numeric,date etc)  the way you want it in EXCEL.  You have control over
data but you add another step before you get the file to EXCEL spreadsheet.

Oludare

----- Original Message -----
From: Dwight Slessman <dslessman@nationalelectrical.com>
To: <BPCS-L@midrange.com>
Sent: Tuesday, November 16, 1999 11:13 AM
Subject: RE: data transfer


> I think TEXT is what is being referred to... not TEST.
>
> The problem with TEXT is that all of the data will come down in one cell
> and you will then need to parse it into seperate cells.  You could use a
> comma delimited file type but this can cause problems if your actual data
> fields happen to contain a comma or a double quote.
>
> Regards,
>
> Dwight
>
> -----Original Message-----
> From: Kenneally, Veronica [JNJIE] [SMTP:VKenneal@JNJIE.JNJ.COM]
> Sent: Tuesday, November 16, 1999 10:07 AM
> To: 'BPCS-L@midrange.com'
> Subject: RE: data transfer
>
> I assume you mean DIF as test is not a type
>
> -----Original Message-----
> From: oludare [mailto:oludare@ix.netcom.com]
> Sent: 16 November 1999 14:31
> To: BPCS-L@midrange.com
> Subject: Re: data transfer
>
>
> 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
> +---
> +---
> | 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
+---