Re: Download Data to Excel

["Walden Leverich" <walden@xxxxxxxxxxxxxxx>]

Just remember Excel95 and earlier can only hold about 16,000 records.
Excel97 can hold up to 64,000. More that that and you need Access, FoxPro
or other "real" pc database.

-Walden
 ----
From: Bob Larkin <blarkin@wt.net>
To: MIDRANGE-L@midrange.com
Date: Thursday, April 24, 1997 11:49 PM
Subject: Re: Download Data to Excel

>Jim Waymire wrote:
>>
>> I need to download some AS/400 files into Excel using Rumba.  Can
>> someone walk me through this?
>>
>> Jim Waymire
>> Crowell, Weedon & Co
>> 800-233-2926 x 318
>Easy one, just follow these steps:
>1. Open Download from a Rumba Session (Looks like a folder w/ arrow)
>2. Make sure it is configured to right machine.
>3. Input AS/400 file name as LIB/FILE(MBR) (Right side of screen)
>4. Click options. Choose fields desired, and any slecetion criteria.
>5. On left side enter PC file Name
>5. Check options and select BIFF (Excell) format
>Go.
>File will be read into Excel as a XLS file, but it is pre Release 6.o,
>so when you save it, you will be prompted for whether to
>
>--
>Bob Larkin
>Larkin Computer Consulting
>blarkin@wt.net
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>* This is the Midrange System Mailing List!  To submit a new message,   *
>* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
>* this list send email to MAJORDOMO@midrange.com and specify            *
>* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
>* should be directed to the list owner / operator: david@midrange.com   *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
> 

* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *