Verify that the field header names in an Excel file match those in the resulting table

Or, 2nd option, use the tabldefs collection to check your columns names (still start by linking your spreadsheet), this can be done with an helper function:

Public sub Program
        '// Ensure the spreadsheet is linked first

    Dim db As DAO.Database
    Set db = CurrentDb

    Dim Source As DAO.TableDef
    Set Source = db.TableDefs("tblTEMPImportRecords ")

    Dim Target As DAO.TableDef
    Set Target = db.TableDefs("TargetTable")

    Dim Field As DAO.Field
    For Each Field In Target.Fields
        If Not (ExistInCollection(Field.Name, Source.Fields) Then
            '// column don't exist, react accordingly
        End If
    Next

        '// Ok to perform the import from here
End Sub

Select allOpen in new window

Public Sub ExistIncollection(ByValKey As String, byref Col As Object) As Boolean
   ExistIncollection = ExistIncollectionByVal(Key, Col) Or ExistIncollectionByRef(Key, Col)
End Sub

Private Sub ExistIncollectionByVal(ByValKey As String, byref Col As Object) As Boolean
On Error Goto Error
    Dim Item As Variant
    Item = Col(Key)
    ExistIncollectionByVal = True
Exit Sub
Error:
    ExistIncollectionByVal = False
End Sub

Private Sub ExistIncollectionByRef(ByValKey As String, byref Col As Object) As Boolean
On Error Goto Error
    Dim Item As Variant
    Set Item = Col(Key)
    ExistIncollectionByRef = True
Exit Sub
Error:
    ExistIncollectionByRef = False
End Sub

Select allOpen in new window

I can't link to the spreadsheet because more than one will be importing. importing into a temporary table.

I can't link to the spreadsheet because more than one will be importing. importing into a temporary table.

More than one spreadsheet or more than one user ?

In the 1st case, what prevent you from linking / unlinking each spreadsheet ? (link a sheet, process it, unlink it. Rince repeat with other sheets).

In the 2nd case, each user should have a local copy of the front-end, where the temporary table(s) will be created before writing data to the back-end. I don't see any reason to prevent from linking / unlinking either.

Else, maybe import specs (can't answer more as I never use those).