Low memory usage

[Phorkyas]

Greetings Tek'ies

I tried the search but all i find is "too much memory usage", my problem is actually the other way round:

Im currently working on a data-intesive Database (>1GB) and also have to handle import via *.csv files with single file sizes >250MB.
The fastest and most suitable way of importing (since i need to make some adjustments on the way) was to link the *.csv files programmatically (via docmd.Transfertext) and then append the needed data via a INSERT INTO query to the tables i needed.

I now want to speed up the appending part further.

The machine im running on has 2GB Ram, quad core prozessor, win XP and plennty of hard disc.
What i noticed is that even while the append querys are running Access only uses 25% CPU (make sense since no multi-core is supported) and only arround 80Mb of RAM.

I am wondering about the RAM-part. This does mean Access handels the whole importing via hard disc which is slow. Why does it not use the Memory to load the whole csv file?
Can i somehow 'tell' Access to use more Memory?
Would that even speed things up?

Please some explanaition on the Memory usage of Access.

Thanks in advance
Phorkyas

 

[kjv1611]

My guess is that the reason this seems to be more disk based is because you're dealing with large data sets, but not necessarily much processing. You're moving the data from one source to another, but not processing the data - no calculations, really. Therefore, the CPU and RAM would not have to work hard on that.

But that's just a guess.