How to Open MySQL Database With MS Access

Follow this easy step by step tutorial to learn how to open MySQL database in Microsoft Access, through an ODBC connection.

Don't forget to check out our site http://howtech.tv/ for more free how-to videos!
http://youtube.com/ithowtovids - our feed
http://www.facebook.com/howtechtv - join us on facebook
https://plus.google.com/1034403827176... - our group in Google+

It can be needed in many situations to link our MySQL database to any other database, spreadsheets or reporting tool. This tutorial will focus on one of the same scenario in which we will learn to open MySQL database.

Step 1- Control Panel
To link MySQL with Access, first of all, we would have to make an ODBC connection. For this purpose, open up control panel and click on the System and Security option

Step 2-Administrative Tools
After that, move to the Administrative Tools option.

Step 3-ODBC Connection Option
Click on the ODBC data source option.

Step 4- Making System DSN
ODBC data source admin window will open up. Over here, move to the DSN tab and click on the Add button.

Step 5- Driver for MySQL
Now scroll down the list, choose MySQL ODBC driver and click on the Finish button.

Step 6- Configuring ODBC Connector
A configuration window will open up.
Give a name to the data source, type "local host" in the server field, specify "root" as a user, because it is a default user in all MySQL instances, and write the name of the desired database in the database field.
Finally, click on the Test button.

Step 7- Connection TEST
A message will pop up confirming that the connection is successful. This means that now we would be able to link MySQL with Access.

Step 8- Microsoft Access
Now, open up Microsoft access, click on the Blank database option and let's create a new database.

Step 9- External Data
After that, move to the "External Data" tab and click on the More option. With that done, a drop down menu will appear on the screen. From the menu, choose the ODBC database option.

Step 10- Linked Table
Within the new window, choose the "Link to data source" option and hit Enter.

Step 11- Machine Data Sources
A window will open up where we will be required to choose the data source connection. Over here, move over to the Machine Data Source tab, choose the same DSN which was created earlier and hit Enter.

Step 12- Selecting tables
After that, it will show us all the tables which our database contains. We can choose any table individually or select all of them.
For this tutorial, we will select all the tables in the database.

Step 13-Database Imported to Access
After that, all of the database tables would appear in Microsoft Access

And that is how to open Mysql database from Access.

---

Closed Caption:

in this tutorial we will guide you on
how to open my SQL database with ms
access for that we would have to make an
odbc connection for this purpose
open up your control panel and click on
the system and security option over here
move to the administrative tools option
and once the new window opens up click
on the ODBC data source option with that
done the ODBC data source admin window
will open up over here moved to the DSN
tab and click on the Add button now
scroll down the list choose mysql odbc
driver and click on the finish button
after that a configuration window will
open up in that give a name for your
data source type localhost and the
server field specify route as a user
because it is a default user in all my
SQL instances and write the name of your
desired database in the database field
after that click on the test button a
message will pop up confirming that the
connection is successful
now open up microsoft access
database option and let's create a new
database after that move to the external
data tab and click on the more option
with that done a drop-down menu will
appear on the screen over here choose
the odbc database option with the new
window opened up choose the link to data
source option and hit enter a window
will open up where you will be required
to choose the data source connection
over here
move over to the machine data source tab
choose the same DSN which you created
earlier and hit enter after that it will
show you all the tables with your
database contains you can choose any
table individually or select all of them
for this tutorial we will select all the
tables in the database now you will be
required to choose the field or fields
that identify each selected table after
that all of the database tables will
appear in microsoft access you can see
that the table structure is the same as
it was in the database enabling you to
comfortably manage your database through
microsoft access and that's it