Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Import MS Access Data to MySQL 5
Nov 29, 2006 @ 13:41:05

In this new tutorial on PHPBuilder.com, Ken Lin demonstrates how to import some data from an MS Access database into the most recent version of MySQL (version 5).

In this article, I will discuss whether or not to migrate your MS Access data to MySQL. Then, I will cover about the considerations, planning, and preparations which should made before migrating your data.

He follows the (good) practice of plan first, shoot later when approaching the subject. He talks about the differences between the two systems, when to and not to make the import jump, and some steps to do to prepare things for the leap.

He choses the Navicat tool to make the transition, stepping through the process the import wizard will follow to make the push much easier than a manual import/export.

tagged: msaccess data database mysql navicat tutorial msaccess data database mysql navicat tutorial