I need an access database that will read data from a text file and put the data in the access form. The format of the text file will be the following
Employee number(number), LastName(string), DateIn(number), TimeIn(string), TimeOut(string)
756, smith, 20031012, 10:00AM, 12:00PM
756, smith, 20031012, 1:00PM, 5:00PM
756, smith, 20031013, 10:00AM, 11:00AM
789, Cris, 20031013, 11:00AM, 12:00PM
I've already have a Recruiting database, I want to import the timesheet functionality into my database.
The output of the form will be the following
Day Date TimeIn TimeOut Hours TimeIn TimeOut Hours Total Daily Hours Weekly Hours
WED 1 10:00AM 12:00PM 2.0 1:00PM 5:00PM 4.0 6.0 20
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Exclusive and complete copyrights to all work purchased. (No GPL, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site).