I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson

Hey Dave,
Thanks for the quick response. Yes, as an alternative, I ended up
creating an ASCII file & and reading that file into EXCEL. Although, I'm
curious why I could do it in EXCEL 2000 with no problem, prior to me
converting to EXCEL 2002. You would expect EXCEL 2002 to be comparable.


"Dave Peterson" wrote:

Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson

For me, the Client Access addin would never do more than 16384. I always
thought that CA didn't want to update their addin from xl95 days.

I don't know how you got more in xl2k??!!??


StanTheMan wrote:

Hey Dave,
Thanks for the quick response. Yes, as an alternative, I ended up
creating an ASCII file & and reading that file into EXCEL. Although, I'm
curious why I could do it in EXCEL 2000 with no problem, prior to me
converting to EXCEL 2002. You would expect EXCEL 2002 to be comparable.


"Dave Peterson" wrote:

Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson


--

Dave Peterson

Problem solved: My Client Access was @ (Ver 4 Rel 4 Lvl 0). I upgraded my
PC for CA from our AS/400 to (Ver 5 Rel 2 Lvl 0). I can now process records
over 50,000 using File transfer on EXCEL 2002. I think the maximum is about
64,000.

"Dave Peterson" wrote:

For me, the Client Access addin would never do more than 16384. I always
thought that CA didn't want to update their addin from xl95 days.

I don't know how you got more in xl2k??!!??


StanTheMan wrote:

Hey Dave,
Thanks for the quick response. Yes, as an alternative, I ended up
creating an ASCII file & and reading that file into EXCEL. Although, I'm
curious why I could do it in EXCEL 2000 with no problem, prior to me
converting to EXCEL 2002. You would expect EXCEL 2002 to be comparable.


"Dave Peterson" wrote:

Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson


--

Dave Peterson

Thanks for posting back. (Now I know that CA _did_ update their addin.)

StanTheMan wrote:

Problem solved: My Client Access was @ (Ver 4 Rel 4 Lvl 0). I upgraded my
PC for CA from our AS/400 to (Ver 5 Rel 2 Lvl 0). I can now process records
over 50,000 using File transfer on EXCEL 2002. I think the maximum is about
64,000.

"Dave Peterson" wrote:

For me, the Client Access addin would never do more than 16384. I always
thought that CA didn't want to update their addin from xl95 days.

I don't know how you got more in xl2k??!!??


StanTheMan wrote:

Hey Dave,
Thanks for the quick response. Yes, as an alternative, I ended up
creating an ASCII file & and reading that file into EXCEL. Although, I'm
curious why I could do it in EXCEL 2000 with no problem, prior to me
converting to EXCEL 2002. You would expect EXCEL 2002 to be comparable.


"Dave Peterson" wrote:

Are you using Client Access?

IIRC, the last version of CA that I used only supported 16384 rows when
transfered to excel (xl95 row count).

I'm not sure if CA ever updated that addin for more rows.

I haven't used it in a while, but I think I'd dump the data to an ASCII file and
then open that ASCII file in excel.

Does that ring a bell with you?

StanTheMan wrote:

I converted to EXCEL 2002 and attempting to do file transfer from AS/400
machine. On my previous EXCEL 2000 version, I could read over a maximum of
50,000 records. With EXCEL 2002, I get a message" The data will not fit in
the worksheet" and stores exactly 16,351 records. What do I do to read the
maximum number of records ?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson