Reading Access Files in OSX
February 25, 2006 — dlkinneyI was given a Microsoft Access database (MDB file) containing an old mailing list. I didn’t want to fire up my long-dormant PC just to open this file, so I looked for alternatives available on OSX. A quick Google search popped up Actual Technologies, who—as luck would have it—just released a read-only Access ODBC driver for OSX. I grabbed the trial version and it worked slick as could be.
The installation was painless, but requires administrative rights. After the ODBC driver was installed, I used the ODBC Manager to configure an ODBC connection to the Access file I received. This opened the Actual Technologies configuration wizard which made the setup a snap. Once the ODBC instance was defined, I was able to open Excel 2004 and pull in the records without any difficulty. The trial edition limits the result set to three rows, but it was obvious that the product did exactly what I needed.
Here’s an interesting detour for you, though. I actually took the time to scan the license agreement and was surprised to see that the license included the copyright for an open source project to read MDB files. Well, who needs a commercial product when you can have the open source product on which it was built?! Too bad that it didn’t compile under OSX. Well, it might have compiled with enough work. The ./configure script wanted GTK libraries. I thought about it for a few minutes… How far was I will to go to avoid spending $30 bucks? But then the reason I use OSX instead of Linux is that I decided long ago that I’m willing to trade money for mortality (time); I’m willing to pay to not have to futz around making things work. I love OSX for many reasons, but the biggest is that it just works.
So Actual Technologies got my money and I got a license key to unlock the driver to return more than three rows. The product works exactly as advertised and I highly recommend it. And Actual Technologies is local to Chicagoland, so I’m helping the area technology industry. Go me!
February 28, 2006 at 1:44 pm
When I was in this boat a little bit ago I went the creatively named Access to MySQL, a small freeware app that can dump out a plain text .sql file from an Access database. It’s Windows-only, so I know that’s cheating, but it works.
March 4, 2006 at 9:05 pm
I looked at that. I didn’t want to have to deal with MySQL and I really wanted a pure-Mac solution.