Re: File transfer

[Pete Hall <pbhall@xxxxxxxxxx>]

At 05:34 06/07/2001, Fiona Fitzgerald wrote:
>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 ?

You may be plummeting headlong to oblivion on that one. I believe the limit 
in excel is 65535 rows. You could use an MSQuery to retrieve the data 
directly from the AS/400 database though. It's in the Excel data menu (get 
external data). MSQuery is an installable option with Excel.
Pete Hall
pbhall@execpc.com
http://www.execpc.com/~pbhall/

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