Re: CA400 Transferring from AS400 in Excel Format.

[Bob Larkin <blarkin@xxxxxx>]

The real question might be - Why are my user's downloading 16,000 rows of data 
to
a spreadsheet? Thats about an 80 page report. What do they need the data for?
Canyou provide the information is a summarized form?
We had a business analyst that was using Access with ODBC to produce reports for
the users. (Unbeknownst to us!) When did we find out? When the number of rows
became too great for ACCESS!! turns out they were downloading the entire DB to
produce FIVE summary rows of less then ten fields.  It took all of 15 minutes to
generate an SQL statement, CL driver, and schedule it. They now have a FIVE row
table available to satisfy that particular need.
Bob

Bill Erhardt wrote:

> I think the question should be, Why does Client Access limit the
> transfer at all?  Logically, one could argue that IBM is just conforming
> to the MS standard, but the standard has changed, so why didn't
> (doesn't) IBM change.  The other approach, is to allow the end user to
> decide which files are "downloadable" in an excel format.  This is the
> approach that Wall Data has taken with it's RUMBA file transfer.  In our
> case, we have been working very hard to move our user base to CA/400 and
> we have been very successful at it.  That is until we ran into this
> brick wall.  Now the user has a valid case not to change.
>
> > -----Original Message-----
> > From: Peter Dow [SMTP:pcdow@yahoo.com]
> > Sent: Monday, February 28, 2000 1:34 PM
> > To:   MIDRANGE-L@midrange.com
> > Subject:      Re: CA400 Transferring from AS400 in Excel Format.
> >
> > I believe that's a limitation prior to Excel 97. From the Excel 97
> > help I
> > found:
> >
> > "Maximum worksheet size  65,536 rows by 256 columns"

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