Query Excel worksheet in MS-Access VBA (using ADODB recordset)

Answer 1

In your connection string you say

 Excel 8.0;HDR=Yes

Which means that the first row will be treated as the header, no matter what it contains. If you want to use F1, F2 etc, say

Excel 8.0;HDR=No

Answer 2

Because you have the HDR=Yes option, the column name should be the data in the first row.

http://support.microsoft.com/kb/316934