Connect Access 2010 to MySQL

If you want to be able to use the tools found in Microsoft Access 2010 with your MySQL data here is how to do it.

1. You need download and install Connector/ODBC
2. Once installed open Access and click on OBDC Database under External Data, and select “Link to the data source by creating a linked table”.

3. Under “Machine Data Source” click “New”

4. Click Next

5. Select MySQL OBDC 3.51 Driver and click Next

6. Click Finish

7. Input your database data

 

For additional information go to http://www.washington.edu/itconnect/web/publishing/mysql-access-3.5.html

Leave a Reply