Got around this by putting in an additional excel source (formatted for excel 2003) and a union all task. Only one of the excel sources will successfully output the data in the correct format but we have too many rows so added a script component to filter out the rubbish.

This seems to work quiet well and also allows us to add further formats at a later date as and when we get them.