RE: data transfer

Veronica,

The question regarding the two file types.  DIF files are an old format.  I 
think it stands for Data Interchange Format and originated I think back in 
the early days of Lotus as a means of importing information into 
spreadsheets.  The BIF format is more of a "native" Excel format.

I am curious as to why files created through Query/400 do not download for 
you properly.  They should as we do this frequently.  Files created through 
Query/400 are, in a sense, created with DDS and should normally have field 
names.  I am not sure what you mean here.

I am also not sure why the warning is issued concerning DIF and BIF and not 
getting your "DATE" transferred correctly.  In either case, the data will 
be transferred as a "number" in the format of CCYYMMDD.  The spreadsheet 
will not be able to deal with this directly as a true "date" type field.

If your file contains fields defined on the AS/400 with DDS as true "date" 
fields, the transfer should work fine and the spreadsheet will see a 
"date".

Regards,

Dwight Slessman
National Electrical Carbon Products, Inc.


-----Original Message-----
From:   Kenneally, Veronica [JNJIE] [SMTP:VKenneal@JNJIE.JNJ.COM]
Sent:   Tuesday, November 16, 1999 9:20 AM
To:     'BPCS-L@midrange.com'
Subject:        RE: data transfer

thanks FOR THE FEEDBACK to this request

so far I have learnt 2 methods

1.In the PC file section of the file transfer , select details , then 
select
file type DIF.
2.on the Details box
on the Data Transfer From AS400 window, the file type drops down into
multiple
file types one of which is BIFF5(MS Excel 5). This also transfers the field
names from the AS400 physical file into the first record on the file - the
file
on the AS400 MUST have a DDS i.e. cannot be created through query etc. for
the
download to work properly.( This I have tested and it will download files
created from query)


What is interesting is that there is a difference in size between the 2
downloaded files

File downloaded using type DIF 58kb
                                BIFF5   41kb

For a samll size this wouldn't make a difference but for the larger files
downloaded it would.

Is there any major difference between the two formats?

Regards
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>
        
-----Original Message-----
From: Kenneally, Veronica [JNJIE] [mailto:VKenneal@jnjie.jnj.com]
Sent: 16 November 1999 11:23
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
+---