Out of Disk Space Error???

[John T Ingato]

Every week I import an Excel spreadsheet into my database, into a particular
table "SalesData 2006". This table at present has 758329 record, with 5
fields per record.

I tried to import the new worksheet today but I am getting an error message
that states,
"Your computer is out of disk space"
"You wont be able to undo the paste append. Do you want to continue anyway?"

I have 47GB left on my only harddrive. Surely enough. Any suggestions?

 

[John T Ingato]

The database is only 101mb. As for the error message :

"Your computer is out of disk space"
"You wont be able to undo the paste append. Do you want to continue?",

I decided to continue with the append anyway and it appeared to import, but
obviously there are issues. I do not know where to begin to look.

 

[John Spencer]

The problem is probably the number of records you are importing.

The import is running in a transaction and cannot get all the temporary records
into the transaction file (which can be in memory or written to a temporary file
on a hard drive), so it gives you the choice of stopping or continuing without
the ability to undo. Temporary file size is limited by your system settings.

If you continue the import, the import is no longer running in a transaction and
cannot be cancelled. There is really nothing wrong, just that you cannot UNDO
the import.

 

[John T Ingato]

OK. That is something I can understand. The only thing is I am inporting
from Excl, so we already know that the max record is 65536 records. I do
know that the record count was more like 35000. Also, I have already
imported 48 weeks of the same amount of data each week without any issues.
What would cause this transaction overload now?

system settings info 2 gig ram, 48gb HD space left

Any ideas?

 

[John T Ingato]

OK. That is something I can understand. The only thing is I am inporting
from Excl, so we already know that the max record is 65536 records. I do
know that the record count was more like 35000. Also, I have already
imported 48 weeks of the same amount of data each week without any issues.
What would cause this transaction overload now?

system settings info 2 gig ram, 48gb HD space left

Any ideas?