Office 97:

I want to read data cell by cell from Excel and add the data to an Access
table with the command AddNew:

With rstTemp
.AddNew
!Time = strTime
!Name = strName
.Update
.Bookmark = .LastModified
End With

This works fine as long as the data shall go to the field "Name". But I want
to replace the !Name with a variable, so that I can copy data from various
columns in Excel and use the value of the top cell in the column to find the
right column in Access.

Do You have any solutions?

regards

Finn