I understand what you are trying to do, I think there is a very easy way round it:
Instead of importing the file directly into your master sheet ("DATA"), import them into a temp sheet ( which you can create and then delete at the end) , thne copy the rows which have data into your master sheet.
I would do the copy using variant arrays but you could do using filter and range to range copy.