I would like to transfer some data from Access and onto Mysql. Not sure about how to do this and am thinking that it could damage data. Do you think it can be performed with no loss of time and data?
You can look into programs such as Informatica or Talend Open Studio (open source) which are quality tools. You should not loose data or time during this operation.