I just found out that MySQL does not read MS Access files but I know it is possible. How can I let MySQL read MS Access database or even convert it to MySQL?
To import files in MySQL, make sure first that your database is a valid open data source. If that has been done, then follow these instructions.
Â
1. Go to Start, and search for ODBC. Â
2. Click on the Data Sources (ODBC).
3. If necessary, type your administrative password then click "System DSN".
4. Choose the "MySQL driver" then "Finish"
5. Click the "Add data source name" and enter all the necessary information such as, username and password, name and server then click OK.
5. Open your Microsoft Access then click "File".
6. Click "Get External Data" then click "Link Tables"
7. A window will open, choose "ODBC Databases ()" and choose MySQL data source.
8. Select the files you want to import, or if all, then Select All then click OK
