I have three users who track their requests on Excel Spreadsheets, until our IT department gets off their duffs and gives them access to the directory where our database is. Each afternoon they email me their excel sheets and I import the data into the BE of the database. However, the database has fields that are not on the excel form (ie. RequestorID, RequestDate, etc...) What I've been doing is importing their work and then using update queries to insert this information into the records. I was wondering if there was a better way.

Thanks.

The only thing I can think of is to get the users to fill those in on the spreadsheet (fat chance?)