Tag: Access

Converting Access to MySQL

For a client, I took on some very old ASP code that desperately needed some TLC before the site relaunches.

While working on the project I had to convert an old Access 2000 file to a MySQL database. I found a free exe that met all of my needs for the conversion and safely moved all of the data: http://www.bullzip.com/products/a2m/info.php

Access to MySQL uses a wizard like interface to allow just about anyone to safely do the conversion. Only problem I had was that I didn’t have the ODBC driver it liked, otherwise it worked very well and was pretty quick.