Converting Access to mySQL

One of those joys within computing which we come across is the need to convert legacy data to a new shiny format.  My current task is to convet a legacy Access database to mySQL so it can be accessed via the web.  It contains data on various scupltures around sussex and will be available at http://www.publicsculpturesofsussex.co.uk

To convert the database I found a GPL’ed application (http://www.bullzip.com/products/a2m/info.php) which is able to produce a mySQL database dump file or connect to the database and create a replica.  Through a simple Windows installer and GUI wizard the task was made suprisingly trival, with the whole process taking less than 5 minutes.