Importing MySQL DB to MS Access

How may I do it?

[henry0]

I was recently reading something in that range:
<<<
To find how building complex queries such as joins
I use the MS access query builder.
select the SQL view.
copy and paste!
>>>
I think it might be a great way to learn on writing correct join query.
out of curiosity I would like giving it a try
by importing one of my MySQL DB on access

But I do not know how to do it.

[siMKin]

i have no experience with this query builder, but i doubt you'll learn something from it.
The key to complex queries starts with a good structure in your database / a good database model. Once you understand the logic behind that, queries such as joins will come naturally. A join is nothing more then linking 1 table to the other, but if your database model is incorrect you'll never be able to succesfully join your tables. Not even after 1 year experimenting with things like query builders.

So my advice is to do some googling for tutorials and just try the joins as you work your way through them.

Anyways, to answer your question: i don't know how you can directly export both structure and data to ms access. But what you could do is just to create the tables manually in ms access, then export your data from mysql to a CSV file and import that into ms access

[Iguana]

You don't really need to import the MYSQL data into Access. You can attach to those tables through the MySQL ODBC (or OLEDB) driver