MS Access Export Utility

This is a utility for programmers who want to migrate a Microsoft Access database into MySQL. MdbToMySQL reads an MDB file and dumps out a text file (preferably with the extension *.sql) containing MySQL strings for building and filling the database. To use it, doubleclick "MdbToMySQL.exe," locate the MDB database file, select the tables to export (check-mark them or click on [All]), choose "What to export," make some "Options" (default setting should do fine), click "Export MySQL file," and choose the destination file. Now activate your Import Tool on the server (like phpmyadmin) and import that just-created file. (If there is no special import function, look for Sql Execute or similar.) Note: No compatibility information was listed, but this application was successfully installed on Windows XP.


Popular posts from this blog

Using Windows 2012 NFS with VMware ESX