Create an ms-dos batch file  to automate the mysql  databae import from
the command line.

Save the worksheet as a .csv

Run the batch file from VBA with the shell function.

Sorry I cant provide any code examples - it's on my work pc, not at home.