Is there a way to import a text file with no line delimiters without
resorting to VBA? The file I need to import has field-width fields
padded with spaces. The first field of the next row starts immediately
after the end of the last field of the previous row -- there is nothing
to indicate the end of a line/record.

I have used the import wizard to import similar files with line
delimiters and it does just what I need. If there is a way to do the
same thing with this wretched delimiter-free file, I will be very
pleased to hear it.


--
mikewilsonuk
------------------------------------------------------------------------
mikewilsonuk's Profile: http://www.excelforum.com/member.php...o&userid=35404
View this thread: http://www.excelforum.com/showthread...hreadid=551781