RE: Data Transfer

["Andy Nolen-Parkhouse" <aparkhouse@xxxxxxxxx>]

Steven,

I would think that somewhere there is a difference on the PC side.  When
I look at the help for my version of Excel (2002 SP-2), I see that the
maximum number of rows is 65,536.  Is this by any chance the number of
rows obtained when you write "over 65000 rows"?  If that is the case,
you may not be getting accurate results there either because you are
exceeding the limits of Excel.  According to Microsoft Technet, the
maximum number of rows in Excel 97 is 16,384.

I find these numbers uncannily similar to the ones you report.  I
realize you think that all of your users are running the same version of
Excel, but it might be a good thing to double check.  I would also
verify on the AS/400 how many rows should be obtained.  Given your
numbers, it's a good chance that no one is getting the right amount.

Regards,
Andy Nolen-Parkhouse



> On Behalf Of steven.donnellan@simonjersey.com
> Subject: Data Transfer
>
> This is a multipart message in MIME format.
> --
> [ Picked text/plain from multipart/alternative ]
> My users are on Client Access Express.
> When some users transfer files in to excel, they can get over 65000
rows.
> When other users transfer files in to excel they get around 16000
rows.
> They use a mixture of .dtf and .tto transfers, but that doesn't seem
to be
> the cause of the problem.
> What can I do to get everyone transferring at 65000 rows?
>
> Steven Donnellan