Spreadsheet too big???

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

John Laird - 23 Dec 2005 17:43 GMT

Sometime ago I built a database which uses an EXCEL spreadsheet for one of
the tables through the Link Table command. For the last year or so
everything has worked fine but now the spreadsheet has exceeded 16,383 rows.
The ACCESS table will not read any rows beyond row 16,383. The formatting in
the spreadsheet has not changed.

The only way all data is visible is when I do the following:
Open the Excel spreadsheet which holds the data;
Open Access and open the linked table.
All data visible.

BUT when I close the table (keeping Access still open), close the
spreadsheet and then reopen the table, only 16,383 rows/lines are visible.

I am using ACCESS97 and EXCEL 2000.

It seems like I have reached some sort of barrier or maximum but I don't know
if it the solution is in Excel or Access.
Any thoughts would be appreciated.

Reply to this Message

Douglas J. Steele - 23 Dec 2005 18:26 GMT

If I recall correctly, Excel 2000 increased the maximum number of rows that
could be stored.

Access 97, of course, doesn't know that...

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Sometime ago I built a database which uses an EXCEL spreadsheet for one of
> the tables through the Link Table command. For the last year or so
[quoted text clipped - 18 lines]
> if it the solution is in Excel or Access.
> Any thoughts would be appreciated.

Reply to this Message

John Laird - 23 Dec 2005 18:35 GMT

My company also has a few ACCESS2003 copies. I'll try in that and see if
I'll be able to "see" more rows.
Thanks for the tip.

>If I recall correctly, Excel 2000 increased the maximum number of rows that
>could be stored.
[quoted text clipped - 6 lines]
>> if it the solution is in Excel or Access.
>> Any thoughts would be appreciated.

Reply to this Message

John Laird - 28 Dec 2005 20:58 GMT

I just tested ACCESS2003 and its ability to "see" beyond 18000+ rows in EXCEL
for a linked table...And it worked!!!
Now I just have to convince my company to replace ACCESS97 completely.
Thanks for the tip. It was right on.

>My company also has a few ACCESS2003 copies. I'll try in that and see if
>I'll be able to "see" more rows.
[quoted text clipped - 5 lines]
>>> if it the solution is in Excel or Access.
>>> Any thoughts would be appreciated.

Reply to this Message