1

I have an .mdb file that a coworker wants me use to convert to tables on our MySQL server. I'm familiar with MySQL, but have very little experience with Access (nor do I really want to learn).

Any suggestions on where to find out the information I need?

5
  • which version of mysql are you running? It matters because most version of mysql are missing features present in Access.
    – Zoredache
    Nov 4, 2009 at 21:19
  • I don't know if I'd call those...things..."features". Nov 4, 2009 at 22:25
  • If it simplifies the user experience and increases their productivity, its a feature.
    – sclarson
    Nov 4, 2009 at 22:31
  • "simplifies the user experience" -- those are UI features. MySQL is a server.
    – Jason S
    Nov 4, 2009 at 22:54
  • Access is perfectly fine for people who really only need a little more than Excel, or people who can't code. Even in those cases, there are a lot of benefits in just using access as a front end, and linking that front end back to a real database. Access performance sucks. Nov 5, 2009 at 1:51

6 Answers 6

5

MS-Access works very well with ODBC to MySQL.

If you have a DSN connection set up, you can import all the tables using the import from external data source. The exact menu commands vary from Access 2003 to Access 2007.

Or you can uses linked tables, which give you a live connection to MySQL tables.

In both cases you'd preserve the meta-data (column types).

I don't recommend using comma separated values or fixed width. You will waste a lot of time re-establishing the meta data (what fields are text, which are dates, etc)

1
  • interesting... so you'd use MS Access's GUI features but move the data to MySQL? sounds like a very promising approach. We'll try it... thanks!
    – Jason S
    Nov 4, 2009 at 22:54
2

If your looking to convert JUST the tables, then I would suggest you export them as CSVs and then import them to MySQL from the CSVs.

1

This is another option - Makes it pretty painless.

http://www.bullzip.com/products/a2m/info.php It will also convert / transfer not just the tables but the records as well.

1

There are a number of tools that will handle Access->MySQL transfers. I like Navicat, but you can download the free MySQL migration toolkit and it works fine with Access.

Access to MySQL is pretty much painless.

0

You can use the converter from the mysqlguitools package to import the data directly to mysql

0

I am doing the migration from a MDB database to MySQL doing some transformations and data validation on the way and the best tool for me right now is Pentaho Kettle (Community Edition). It's free and you can load the MDB database as input, browse the table, make transformations on the data and output as CSV, SQL, TXT, ...

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .