[AccessD] Linked tables have no rows and just field F1

[Bill Benson]

I am trying to link to excel worksheets with this command

      DoCmd.TransferSpreadsheet acLink, acSpreadsheetTypeExcel12Xml,
vListSheets(i), DATA_FILE, True


vListSheets(i) is a particular worksheet. It has headers, and most of the
sheets have data.
DATA_FILE is the Excel file's path.

What happens is each linked table has a field named F1 and the tables are
empty. Probably a rookie mistake I am making... though I am not a rookie,
so I am a little embarassed here. It has been 10 years or more since I used
TransferSpreadsheet to link to an Excel file.