How to import MS-Access MDB ?
Posted by: st n
Date: August 10, 2010 03:05AM


please let me know the most straightforward way to import data from a MS-access-database into mysql using linux (ubuntu 10.04)

- Using odbc and ms-access is one way but 1) it requires ms-windows and 2) I think that this only works if the tables are already in mysql. So transferring data works but creating a mysql-database and its tables does not.

- There are tools for extracting csv-files and also mysql insert-statements from a MDB. I used that before and it works (more or less) but is a bit clumsy, 1) storing lots of data 3 times (in the MDB, in the textfile, finally in MYSQL) and also 2) it requires lots of manual intervention.

So I would be happy to know about some more elegant way.

THX, stn

Options: ReplyQuote

Written By
How to import MS-Access MDB ?
August 10, 2010 03:05AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.