Impoting data from a MySql database

[Tony Williams]

We have a very small system that has an Access front end with the tables
being held in a MySql database. We don't now have any MySql expertise and
want to rebuild the database in Access. Can someone give me a 123 step
description as to how we import the data from the MySql database to our
newly created Access database.
TIA
Tony Williams

 

[Douglas J. Steele]

Well, to be honest, I've never used MySQL, but you can download ODBC drivers
from http://dev.mysql.com/downloads/connector/odbc/3.51.html

Once you've installed those, inside Access go to File | Get External Data |
Import.

Select "ODBC Databases" from the "Files of Type" combo box, create a new DSN
to point to your MySQL database, then import the tables.

 

[Tony Williams]

Thanks Douglas as I mentioned we do not have any MySql expertise either so
could you clarify what you mean by "create a new DSN to point to your MySQL
database, " ?
Thanks again
Tony

 

[Douglas J. Steele]

You shouldn't need specific expertise with MySQL to create an ODBC DSN.

Once you've clicked on File | Get External Data | Import and selected "ODBC
Databases" from the "Files of Type" combo box, a new "Select Data Source"
dialog opens up. In the middle of that dialog, it's looking for a DSN Name.
There's a "New..." button beside the DSN Name text box. Click on that New
button, and a list of drivers that have been installed on the machine
appears. Find the one that corresponds to the MySQL driver you installed (I
don't know how it will specifically appear in the list, but it should be
obvious). You will then be walked through a number of questions you'll need
to answer to indicate where the database is located and stuff. Again, since
I've never worked with MySQL, I don't know the specific questions you'll
need to answer, but it should be relatively straightforward. If it's not,
hunt around the MySQL site. (
http://dev.mysql.com/doc/connector/odbc/en/faq_toc.html looks as though it
would be a good place to start)

 

[Tony Williams]

Thanks a lot Douglas I'll have a go.
Tony

You shouldn't need specific expertise with MySQL to create an ODBC DSN.

Once you've clicked on File | Get External Data | Import and selected "ODBC
Databases" from the "Files of Type" combo box, a new "Select Data Source"
dialog opens up. In the middle of that dialog, it's looking for a DSN Name.
There's a "New..." button beside the DSN Name text box. Click on that New
button, and a list of drivers that have been installed on the machine
appears. Find the one that corresponds to the MySQL driver you installed (I
don't know how it will specifically appear in the list, but it should be
obvious). You will then be walked through a number of questions you'll need
to answer to indicate where the database is located and stuff. Again, since
I've never worked with MySQL, I don't know the specific questions you'll
need to answer, but it should be relatively straightforward. If it's not,
hunt around the MySQL site. (
http://dev.mysql.com/doc/connector/odbc/en/faq_toc.html looks as though it
would be a good place to start)