CODEWITHSUNDEEP
sqlmysqlms-access
bmw0128
bmw0128

Reputation: 13698

Migrate MS Access to MySQL

I'm getting data as an Access file.

My application uses MySQL/Java. I'd like to parse the Access data, and stick it in MySQL.

Is there a Java tool that will help me do this?

Upvotes: 1

Views: 1363

Answers (2)

Tony Toews
Tony Toews

Reputation: 7882

MDB Tools is a set of open source libraries and utilities to facilitate exporting data from MS Access databases (mdb files) without using the Microsoft DLLs. Thus non Windows OSs can read the data.

Upvotes: 1

JohnFx
JohnFx

Reputation: 34909

If this is a one time conversion just use MS-Access, link to your MySQL database tables and use update queries to transfer the data.

If your app needs to import Access data into MySQL on a continuing basis you could connect to Access via ODBC and then have your app write the data to MySQL.

Upvotes: 1

Related Questions