How To Read MS Access Files in MySQL

Asked By howel dinh 30 points N/A Posted on - 04/11/2012

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?

• Status: Open
• Question Views: 1147
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MySQL Server

Answered By Montebon Mil 0 points N/A #110566

How To Read MS Access Files in 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

About Montebon Mil

Questions
5

Answers
54

Best Answers
11

• Vote Up 0 Vote Down

• Posted on - 04/11/2012
• Question Category: MySQL Server