I forgot that you were using a form method. Form methods by nature do not lend themseleves to this method though it can be done. One simply adds the fieldnames to some Sheet that could be hidden, and in row 2, one references the cells from the "field" sheet. You can name a range or just use a bracket method to set the range.

You can make forms in Access and skip Excel alltogether.

If you do want to stick with Excel, we will have to use ADO methods. A more robust method can be used to skip the intermdiate step that I explained in the first paragraph. It will be more hard to understand but once you understand the concept, it is not that bad. Both of these ADO methods will work.

If you want to purse one of the 2 ADO methods, let me know which one. I can help you with a more specific code for your xls and mdb.