Jump to content

Archived

This topic is now archived and is closed to further replies.

nick1

Migrating an msAccess DB to MySQL

Recommended Posts

Greetings,

Well, as the subject of this post says, I want to convert a microsoft access database into a MySQL database.
I'm already running Ubuntu 6 server with a LAMP installation.  The MySQL server is already up and running and
I've created some test databases.  The Access database is located on a Windows server.
I have full permissions to the Access database and the MySQL database.  I'd like the migration to be as simple
and painless as possible.  Any recommendations on free tools to use?

Thank you for your time,

*Nick*

Share this post


Link to post
Share on other sites
you could use SQLyog with the OBDC driver from mysql to connect to the Access DB and create a SQL file then with the same software connect to the mysql DB and run the sql file to import it into mysql.

I have used this process before to do this.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.