Hi austenr,

I made an add-in for dealing with text files like this. The import portion should do what you need, and can span multiple pages if the text file is huge.
The only reason I haven't publicized it here yet is because when the text files are over 100,000 or so lines, it takes about 2 minutes to import (too long in my opinion). But it can use multiple delimiters if desired as well. Take a look, see if it fits your needs. Put it in your
C:\Documents and Settings\%USERNAME%\Application Data\Microsoft\AddIns
directory, or wherever your addin directory is located. Then go to Tools, AddIns, then check the Text Files checkbox. It adds a menu option for it automatically.
Matt