Why not do the data mining in a database environment? Word is definately not
made to do this type of function and the file is too large for Excel. Have you
tried Access?



"-=Drew" wrote in message
...
: All-
:
: I have a gigantic file that I need to do some data mining into. It's about
: 70,000 pages of flat data records (my best guess- haven't made it to the
: bottom of the file yet...it's 332 meg- :-) ) Word can barely handle it (takes
: over 30 mins), wordpad & notepad can't hang at all. I can't cut & paste when
: I open the file in word, so severing the file into easily manageable sections
: isnt' an option.
:
: I'm trying to import it in a linebyline record format.
: I tried the posted macro for importing more than 65K records- it works well
: but taps out at 1.04 million records. Unfortunately, i need to import all of
: them, and probably will end up needing about 3x that many to be imported (yes
: friends, over 3 million records.)
:
: I can't tell whether the error is a system resource error or if it's some
: limitation in excel.
:
:
: Any suggestions?
:
: Your country owes the one who helps me a debt of gratitude.
: -=Drew