Pervasive Software has some data tools you should look at. You can convert each table in Access to a new MySQL table as long as the MySQL database has been created. It also does a pretty good job of automatically converting data types where they differ. Here's a link to the Pervasive DataTools site. Try the UpLoader to MySQL. I think you'll find it useful.