Hello. I'm testing an Excel import into an Access table but I'm getting a subscript out of range on the import wizard. I'm testing one record and importing into a table that I need multiple key fields. I would load an image but I don't see the option to do that.

In the import wizard, the first screen is not editable where normally it would be. So where you the "First Row Contains Column Headings" is not editable. From there the wizard will only advance to the import action where I get the Subscript out of Range error.

The field names are the same in Excel file and the Access table and are aliased as follows:
<key> Field1 ShortText
<key> Field2 ShortText
<key> Field3 ShortText
<key> Field4 ShortText
<key> Field5 ShortText
      Field6 ShortText
      Field7 Date/Time
      Field8 Number

Thank you for any insight you may have!