Importing Excel Files Into Access Problem?

[Muzzery]

I'm importing an excel file into a database, and at some point through the process, it comes up with this error:

Not enough space on temporary disk.

does any body know what this means? The RAM isn't all used up, and the HDD isn't either.

Thanks

Muzz

 

[thornmastr]

Are you importing more than 1000 rows. If you are, under options>edit/find change the display lists to about 100,000.

Robert Berman

 

[Muzzery]

Thanks, i will try that, but i'm importing the Spreadsheet through VBA code, so i am unsure if this will make a difference?