Closed

Excel data 2 Access : MS office programmer needed

This project was awarded to goodlancer for $100 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
$100 - $300 USD
Total Bids
27
Project Description

Hi,

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

or


EMPLOYEE_ID WEEK_ID (1-53) DAY_OF_THE_WEEK (2-6) EXCEPTION_ID HOURS_MORNING HOUR_AFTERNOON


With kind regards
Maxim Ivashkov

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online