I created an Excel spreadsheet as a template for employee data that multiple
supervisors rename and daily put data into concerning their employees. I
want to create a macro in the Excel template so that the supervisors can
daily export the employee data in their spreadsheet to a particular table in
a multi-user multi-purpose Access database. The data to be exported for each
day can be put into a contiguous area with the Access key field (employee ID)
as the first field and the date as the second field. The only qualification
would be to ask if you want to replace data that has the same employee ID and
date. There is always the possibility that two supervisors might be doing
the export at the same time, but they would not have the same employees.