I have sheet that I've set up that imports data from .txt files created by
another program. I have the query tailored so that it deletes the first 4
rows of the .txt file, as those rows are extraneous info, not the data.

When I run the query on a different file than the one that I created it for,
it is deleting a row from the sheet, which throws the entire sheet off and
feeds column after column of "!REF#" into the following calculation columns,
since this row shift blows everything out of the water. These text files are
all in the same format, and vary only in that some of them have three rows of
data, while others can have up to six. I "blue sky'd" my import space & have
23 rows available for the import.

Any ideas of what's happening here, or any questions that might get me
pointed in the right direction for an answer?

TIA