Need some work done? Post a Project Today
Attention Scriptlance users, Scriptlance has been acquired by Freelancer.com! Find out more
For my customer I need to transform data from Excel into Access. Excel data includes several types of exceptions per employee per day in 2007. Every week has the separate spreadheet which has several types of exceptions per day of the week (see attachment). Additionally the day hours are splitted into two parts- morning part and afternoon part. I would like to have the automated solution to transform such spreadsheets into access database with the format:
EMPLOYEE_ID DATE_ID (1-365) EXCEPTION_ID HOURS_MORNING HOUR_AFTERNOON
EMPLOYEE_ID WEEK_ID (1-53) DAY_OF_THE_WEEK (2-6) EXCEPTION_ID HOURS_MORNING HOUR_AFTERNOON
With kind regards
Freelancer.com (formerly GetAFreelancer, Scriptlance and vWorker/Rentacoder) is the world's largest freelancing, outsourcing and crowdsourcing marketplace for small business. Hire freelancers to work in software, writing, data entry and design right through to engineering and the sciences, sales and marketing, and accounting & legal services.
Find freelance jobs and make money online! We have freelance coders, writers, programmers, designers, marketers and more. Getting the best web design, custom programming, professional writing or affordable marketing has never been easier!
© Copyright 2013 Freelancer Technology Pty Limited (ACN 142 189 759)
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)