First of all, this is a different post from the last. If you were reading
correctly, this is refering to Excel memory issue, not HOW to import large
files.

Second, I said specifically at 1 million lines, thats at number 16 on the
worksheets, that is no where near excessive in terms of worksheets.

However, I have just read something about a maximum of 1 million lines
storable per workbook for excel 2003. Can someone confirm that? And is there
a way around it?

" wrote:

On Jun 26, 12:35 pm, J@Y wrote:
I am importing a large text file into Excel using MS's macro (ie: creating
mulitple worksheets)
After about 1 million lines, I get this error message saying I don't have
enough resources to complete the task. I have about 2 gigs for physiscal
memory and 3 gigs of virtual memory. What exactly is the resources refering
to?

You already posted this message not even 30 minutes ago. Be patient
and try not to add more posts than necessary.

I'm not sure how you are interacting with your text file, but keep in
mind that Excel has a row and column limitation to it (depending on
the version of Excel you have). Also, the more data you have (i.e.
lots of row, column data or lots of worksheets), the more resources
Excel needs to keep track of where all of the data is. If you are
adding hundreds of worksheets than you can expect Excel to get bogged
down.

Matt