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.
- Download the program DBWScript. It has a 30 day license.
- Install and open.
- Point it at your mdb file, then set the output file to MySQL, click next.
- Set your output sql file.
- Run it.
Pretty easy, and saved me more time clicking around Access looking for this missing feature.