I think you're going to have to give an example: that's still too abstract
for me.

PMFJI,

If you just want to get the names of the fields in the new table, you
can open a recordset and look through its Fields collection:

Sub ListFieldsInTable(TableName As String)
 Dim rsR As dao.Recordset
 Dim fldF As dao.Field
 Dim j As Long
 
 'Open a recordset with no actual records
 Set rsR = CurrentDb.OpenRecordset("SELECT * FROM " & TableName _
   & " WHERE FALSE;", dbOpenSnapshot)
 
 With rsR.Fields
   For j = 0 To .Count - 1
     Debug.Print .Item(j).Name
   Next
 End With

 rsR.Close
End Sub

If I understand the situation right you're thinking in terms of a
translation table that maps the field names you expect to find in the
incoming csv files onto the names you have used in your "permanent"
table, e.g.
   CSVField, PermanentField, TableName
    FirstName, FirstName, Contacts
    FName, FirstName, Contacts
    First Name, FirstName, Contacts
   ...

If so, you can call DLookup() in the For..Next loop, and use the values
it returns to build the SQL statement for an append query that maps the
field names for you, along these lines:

 INSERT INTO Contacts (FirstName, MiddleName, LastName ...)
   SELECT FName, MI, LName ... FROM CSVTable;

--
John Nurick [Microsoft Access MVP]

Please respond in the newgroup and not by email.