I have managed to do a bit of a hacky fix to get this working for us. Using good old Excel to save the day.
Ive had a look at the tabels it seems you only need to put the datya in the Course table. So following an IMPORT Query in the following format. I have got Excel to create my FULL INSER query for MySQL. Fired it off and all the courses were there.
Some tweeking was needed but for a 10 minute job I now have all courses in the database. If you need advice drop me a line.