I have a table in Access that contains timesheet data. The timesheet files can have between 1 & 7 days (not every has to be worked) of data and each day will consist of about 19 fields of data.

As part of the weekly payroll run, the data from all submitted Excel based timesheets need to be added to the table.

What code do I need to add all the rows/days of timesheet data to the table in one line rather than having to add each line/day of data individually?

Also, if the timesheet has already been submitted and exists in the Db table, how do I delete that data and replace with the most recently submitted timesheet? It could be that the previous submission has a different number of days worked on it.


Thanks