Re: Download Data to Excel

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