RE: File transfer

[Joel Fritz <JFritz@xxxxxxxxxxxxxxxx>]

Hmm...

I regularly download files with over a million records using CA file
transfer.  The only problem with Excel that I know of is the 64K row limit.
Otherwise I'd recommend using the Excel add in that comes with CA.  

What version of CA and Excel are you using, and what is your output format?
If you're trying to download in Excel format, there may be a limit to the
size that's smaller than the current one since CA supports some older Excel
formats.  

You could download in DIF, CSV, or tab delimited form.  If the 284K record
file needs to be imported to Excel, you or your supplier will need to break
it into smaller pieces at some point.  Bill Gates did make some remark about
640K being enough for anyone that seems to apply here, although in this case
enough is a bit smaller. <g> 

> -----Original Message-----
> From: fiona.fitzgerald@notes.royalsun.com
> [mailto:fiona.fitzgerald@notes.royalsun.com]
> Sent: Thursday, June 07, 2001 3:34 AM
> To: MIDRANGE-L@midrange.com
> Subject: File transfer
> 
> 
> 
> 
> Looking for ideas - one of our developers has promised to 
> send a supplier
> 3 Excel files as e-mail attachments.
> 
> When he runs Client Access Data transfer From AS/400 To PC, 
> it comes up
> with an error window stating that the PC data file limit  is 16,383
> records.
> 
> The largest file has 284,895 records.
> 
> Any ideas ? We could split the files with CPYF, but is there 
> a better way
> to export files to the NT
> server, converting them to Excel along the way ?
> 
> Thanks,
> Fiona
> 
, 
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---