Re: Download Data to Excel

["Walden Leverich" <walden@xxxxxxxxxxxxxxx>]

I regularly pump several million row tables through FoxPro 2.6, quite sure
I've been over 10 Million once or twice.

-Walden

 ----
From: John Carr <74711.77@CompuServe.COM>
To: Midrange-l <midrange-l@midrange.com>
Date: Saturday, April 26, 1997 5:11 PM
Subject: Re: Download Data to Excel

>Hey peoples;
>
>Just wondering, Does anyone know how much a "Real" pc database can
>hold?  1 million, 5 million records?
>
>John P. Carr CDP
>EdgeTech Inc.
>----------------------------------------------------------------
>
>>Date: 4/25/97  4:08 AM
>>RE: 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
> ----
>
>>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   *
>* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
>umidr
> 

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