System Resource Exceeded

[Lisa]

I am trying to append data into a large table. Currently the data is at
52000 lines. When I tried to append the next Excel spreadsheet I get the
error " System Resource Exceeded"

Most of the searching I have done on Microsoft indicates that this is a
complex query issue, however I am not running a query, I am importing
(appending) data into a large table.

I am currently using Access 2000.

My own internal company help desk is useless. Anyone have this issue
before? What can I do to fix it?

 

[PhilT via AccessMonster.com]

I have a same situation with Access 2000, but try to upgrade more memory for
your computer should sold the problem. I have over 800,000 records, and 512MB.
I run crosstab but system stop, I then run the same database in laptop with
1GB, and no error.