http://support.microsoft.com/kb/120596/en-us
"Importing Text Files Larger Than 65536 Rows"
--
Jim Cone
San Francisco, USA
http://www.realezsites.com/bus/primitivesoftware


"JeffMelton"
wrote in message
I remember finding a macro that would fit a text file into excel by
creating new sheets after 65.5k, but I've lost it. Does anybody have
something that can do this for me? Thanks