Geeky Nuggets

Access to MySQL import class

July 18, 2009 | 0 Minute Read

In my latest project at work I need to import data from an Access database into mySQL to be able to create an online shop from that data. Instead of importing just the database of that particular client, I created a generic PHP class that can import any Access database to MySQL.

Big databases must be imported by chunks.

Since Access databases can get so big, the import class has to do its job by chunks, to avoid memory limits. It also needs to reload itself when it detects it is close to the time limit, all of which it now does without any problems. We can now import (hopefully) any Access database.