Having Trouble Thinking Of A Way To Approach This (to Do With Importing Access Data)

Edit:I just realised i had accidently writted the title as (to do with importing access data) it should read (to do with importing excel data)

This is going to be a trick hard to understand question but I will try my best to explain it

I have a database set out in the following way

http://img524.imageshack.us/img524/1350/databasetableli1.png

The way it works is;

Let's pretend Access Programmers is a company and working on different forums is a different job

So on one record it would read

James.90| Access Programmers|Tables Forum| Wed=3= Mon=2

Then the record below might read

James.90| Access programmers | Forms Forum| mon=5 tue=6

So each record is one unique company,Project and CTR which the person has worked for that week meaning if you only work on one forum you would only write one record out each week

Now the data i am receiving is in an excel file where it's set out in a daily basis

Where

One Day Date|Name|Company|CTR|etc

So if a person works 5 days a week on 2 companies each day that is 10 records when it should only be 2 records

So to sum it up. My database is set out weekly and the excel data is set out daily

My question

What would be the best way to convert this data into the database. Changing the database structure around is not an option and i can't change the format we recieve the excel data in. I can change it once i have the file thorough a converter but i can't change the raw source of the data

What would be a way to solve this problem because i am completly stummted and am open to any option of converting or anything

Thankyou for your time. Also if you have trouble understanding what i mean Please say so and i will upload a copy of the database and a copy of the excel sheet!