Have you tried saving the spreadsheet part way through the import. That could
free up some memory. Other than that try monitoring the task manager while
the import is occuring to see what kind of memory is being used. You can also
use application.FreeMemory to have Excel monitor it's memroy and use that to
determine if you need to save or take some other course of action...
--
HTH...

Jim Thomlinson


"pinkyundbrain2000" wrote:

Thanks for the fast answer. It is not what I was hopping to find but it
is a start