RE: data transfer

[Dwight Slessman <dslessman@xxxxxxxxxxxxxxxxxxxxxx>]

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