Thanks for the response but I'm trying to import into MS SQL not mySQL. The problem is I can't seem to get the data into any sort of format I can use, it's all stored in different files et cetera ...

Microsoft Access database migration application convert entire record or selected tables of any password protected MDB or ACCDB file into its equivalent MySQL database server. DB conversion software ...