Linked Excel files... blank leading rows in Query datasheet view and reports

[BrockWade]

I decided to link Excel files and all is running fine except when I run a query on the file I get about 1,041 blank rows before my data is displayed in the query's datasheet view or any report based upon this query... the data seems good but why the leading blank rows? The data in the linked Excel sheet does not look like this and another Excel file's query looks fine and they seem set up indentically! Thoughts?

[June7]

Could be those rows in Excel have empty string in cells. Try creating a new worksheet and copy/paste data from the old sheet. Link to that sheet. The blanks go away?

[BrockWade]

That worked! Thanks!