I have an excel file that I have code written to open an existing access
database, open a certain table and add data from the excel file into certain
fields in a new record. After this, the code saves the excel file (but does
not close it) with a name based on the value of a cell on the worksheet. Now
I would like to add that filename (say it's in cell A1 on the excel sheet for
simplicity) to a field in the record the code just created in access. Does
anyone have the code to add to an existing record or can you only addnew?

Now, what if that field in the record I'm talking about in the access table
is an OLE obect? I basically want to create a link on the access table (and
form based on that table) that will open the excel file when clicked. Maybe
there is a better or different way to do this. I'm up for suggestions.