Downloaded MySQL ODBC driver ... now what?

J

Jamie Risk

I've downloaded the ODBC driver from the MySQL site for use with Access 2002
on an XP machine. Through the control panel I was able to configure the
connection to the database on the web, and tested the connection
sucessfullly.

What do I do now to get Access to hook up to the ODBC source?
 
H

Harley Feldman

In Access select File/Get External Data/. Then choose Import or Link Tables. When the file windows opens, select ODBC Databases() in Files of Type drop down. The ODBC connection box will open. Then select Machine Data Source and select your ODBC database.

Harley
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Export Access Table to MySQL database using C# program 2
add password to circumvent mysql connector pop-up 3
VBA Code to Connect and Query a MySQL Table 12
Link tables ODBC 1
Access2010 redistribuible + runtime e ODBC issue 2
Oracle ODBC Connection Problem 1
ODBC Connector to MySQL server 2
How to configure the user and password for MySQL 2

Top