How to Open MySQL Database With MS Access

MySQL is a popular open-source database that is used in many different applications, especially Web-based applications. You can go through a MySQL database using Microsoft's Access program, but you need to set up the database as a valid open data source before you are able to import this information into your Access program. Once the database is in Access you can navigate through it as you would any other Access database, making changes as needed.

Instructions

1

Type "Data Sources (ODBC)" in the search box on "Start." Click the result and enter your administrative password if necessary. Click "System DSN." Choose the MySQL driver from the list and click "Finish."

2

Click "Add Data Source Name." Enter all of the information for your MySQL database, such as the name, server, username and password. Click "OK."

3

Open Microsoft Access.

4

Click "File." Select the option "Get External Data." Click "Link Tables."

5

Select "ODBC Databases ()" in the explorer window that opens. Select the MySQL data source.

6

Click "Select All" to import all of your MySQL tables into Access. Click "OK."