Hi I'mk new to the site and hope you can help...

I have inherited a databse, and its a mess.

I have one main problem that I have been unable to resolve.

I have 1 table with records in for sickness

ie

IdNo / Name / DateFrom / DateTo / NoOfDaysSick
02119 / Anyone / 01/04/08 / 05/04/08 / 5

What I need to do is to copy this data to another table but put one entry in for each day sick

ie

IdNo / Name / Date
02119 / Anyone / 01/04/08
02119 / Anyone / 02/04/08
02119 / Anyone / 03/04/08
02119 / Anyone / 04/04/08
02119 / Anyone / 05/04/08

I'm new to SQl so any help would be very greatful