I have similar problem as above.

I tried to set the Extended Property of my Excel file Connection,

 HDR=NO

 which will take the first row (the column header) as data.

However, this doesn't really meet my...