Hi!
If I am correct, you need to transform access data in mysql data, right?
So, why we don't make a macro (or a VBA procedure, the best way) to transport these data right from access to mysql?
That's my proposal. All we need is the access database and the mysql database (with all access, of course). My idea is connect mysql inside access and transport directly from the .accdb file.
Please feel free to contact me.
Best regards,