Export from Office 2003 Excel to Access
Each supervisor has 10-20 employees, and this is a once-a-day report on their
employees. The only time there could be duplicates is if a correction needed
to be made, usually only to a few employees, after the data was originally
sent, and that doesn't happen very often. No big deal. So each employee
ultimately has only one record per day. We definitely don't want to confirm
the data transfer for each one, just the completion of the task.
I will try to adapt what you sent and see how it works.
|