Michael Cordell's Blog

Microsoft Access Database to SQL file

I had an existing Microsoft Access database that was quite large that I needed to migrate to a more managable MySQL database. I wanted to export the database to a .sql file for portability sake. Strangely, this feature is absent from Access the program. Here is the easiest solution.

  1. Download the program DBWScript. It has a 30 day license.
  2. Install and open.
  3. Point it at your mdb file, then set the output file to MySQL, click next.
  4. Set your output sql file.
  5. Run it.

Pretty easy, and saved me more time clicking around Access looking for this missing feature.