According to Cordell

Microsoft Access Database to SQL file

By
on

I had an existing Microsoft Access database that was quite large that I needed to migrate to a more manageable 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.