Connect to Excel Spreadsheet, all workbooks but one headers are not coming across

[unclejemima]

I have a excel spreadsheet i'm linked to with about 6 worksheets (tabs) in it.

All have column headers, and when I import them, all worksheets the first row imports as the header name...except one of the worksheets what is formatted identical it imports as column 1 and column 2...and then puts the headers as data in the import.

Any idea how to fix this?

[MattAllington · Accepted solution]

Click Promote first row to headers. It is in the context menu in the top left of the table in query vire