Importing text file with no line delimiters

[mikewilsonuk]

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.

 

[Bernie Deitrick]

No need to learn too much - post in the programming group, and you'll get a good start on it.

 

[mikewilsonuk]

I found some code (in the help I think), copied & pasted it, hacked it
around a bit and added a 'load file' button to the sheet. It works
fine. As you say, there wasn't too much to learn. Thanks for your
advice.