After some mindreading, I came up with this one. The last line of the file that needs to be imported, has to be a blank line (line with no data). You have to run the macro 'DoTheImport'

Hope this will help you a little.

Charlize

ps.: This is a modified version of a routine provided by mdmackillop
No header rows in destination sheet (is active sheet when macro starts to run)