Importing MS Access dataabse in Mysql database

How can we inport MS Ac开发者_Python百科cess dataabse in Mysql database using mysql prompt ?

I know it is possible.

any help ?

---

You will find quite a lot of resources here

---

I use SQLyog as a GUI for MySQL, which I'm very happy with. It has a utility to import data from a number of sources, including MS Access. There is a free Community Edition available, although I find it totally worthwhile to pay the small annual subscription fee for the Ultimate version. HTH.