data upload advice needed
As per the client requirement the data in the excel sheet has to uploaded into IT 2011.
I have to upload the employees' first clock-in and final clock-out data when he leaves the office finally that day.
There can be many records for a single employee in the sheet based on the no of times he swaps-in and swaps out during the day.
I have to consider the initial and final swap in & out time and upload the same in the IT 2011.
For each employee each day two records will be uploaded, one for clock in and other for **** out.
Please suggest how to implement this also the file should be on application server.
Also please suggest the input excel format, in which the data should be present.
This uploading will run on daily basis, as the employee is going and coming to office on a daily basis.