It's possible to write code to open the file, assign the first value read to
a HairColour variable, the second value read to an EyeColour variable and
the third value read to an Age variable, then write an Insert statement
after the third value's been read. In fact, all you really need to do is add
the values to the SQL statement as you read them.

For instance, if you're talking about a simple text file, you could do
something like:

Dim dbCurr As DAO.Database
Dim intFile As Integer
Dim intLineCount As Integer
Dim strFile As String
Dim strSQL As String
Dim strVariable As String

 Set dbCurr = CurrentDB()

 strFile = "C:\Folder\File.txt"
 intFile = FreeFile()
 intLineCount = 0
 Open strFile For Input As #intFile
 Do While Not EOF(intFile)
   Line Input #intFile, strVariable
   Select Case intLineCount
     Case 1
       strSQL = "INSERT INTO TableName (HairColour, EyeColour, Age) " & _
         "VALUES('" & strVariable & "', '"
       intLineCount = 2
     Case 2
       strSQL = strSQL & strVariable & "', "
       intLineCount = 3
     Case 3
       strSQL = strSQL & strVariable & ")"
       dbCurr.Execute strSQL, dbFailOnError
       intLineCount = 0
   End Select
 Loop
 Close #intFile
 Set dbCurr = Nothing