https://systemoverlord.com/tags/access.htmlRecent content in Access on System OverlordHugoen-usdavid@systemoverlord.com (David Tomaschik)david@systemoverlord.com (David Tomaschik)Wed, 21 Sep 2011 22:32:00 +0000https://systemoverlord.com/2011/09/21/migrating-an-access-database-to-mysql/Wed, 21 Sep 2011 22:32:00 +0000david@systemoverlord.com (David Tomaschik)https://systemoverlord.com/2011/09/21/migrating-an-access-database-to-mysql/<p>I'm currently taking a Database class as part of my requirements for my M.S. in Computer Science. Several of our assignments are based on a database provided to us as a Microsoft Access Database. While I have a Windows 7 Virtual Machine, and could install Office in it, I prefer to use free software whenever possible, so I looked for a way to use this database with free software.</p> <p>Fortunately, the database is in the earlier .mdb format, and not the newer .accdb format. I first found a glimmer of hope in an <a href="http://nialldonegan.me/2007/03/10/converting-microsoft-access-mdb-into-csv-or-mysql-in-linux/">article</a> by Niall Donegan describing the use of the <a href="http://mdbtools.sourceforge.net/">MDB Tools</a> package.</p>