Access: Upload a form from Access

[gheyman]

(THIS IS AN ACCESS QUESTION)

I want to upload a form from excel (actual append it). The fields are the same with the exception that my table has a Primary Key field and I have one additional field in my table (BoM_Owner)

When the user uploads the BoM, I want to be able to automatically enter their user name in the last field of the rows they are appending. Is this even possible?

 

[ranman256]

you mean upload DATA from a form?
or
enter ID in the form and download data based on that from the Access DB to the spreadsheet?