I’ve had a bunch of Microsoft Access database files kicking around for the last several months, but due to version incompatibilities, I’ve been unable to open them. I didn’t want to buy a license for the program, just to pull my data out, so I’d looked for alternative ways to free my data from the proprietary clutches of Access.
I’d tried using Open Office, which includes a database program, but ran into the consequences of my own bad planning: Base (the OOo database component) could open Access files, but couldn’t do anything useful with them if they didn’t have a primary key. Most of my files were pretty basic flat files with a single table, so I’d never bothered to add a primary key (yes, I know: bad database practice).
Base would also let me export individual tables or queries to Calc (the spreadsheet component), but the process seemed pretty dicey — it locked up on me three times as I tried to save a new Calc spreadsheet as a .CSV file. I wasn’t comfortable that all the data in the table had been properly captured in the output, either.
Enter Mr. Nolan’s neat little MDB Viewer Plus utility (downloadable from here). It’s just a simple viewer for Microsoft Access files, but it worked a treat on extracting the tables I needed out of the proprietary MDB format to a .CSV I can import into something else (after this experience, something open source by preference).
Update: Aagh! Not quite as clean as I first thought. It appears that any date that has a value of greater than 12 for the day has been dropped. I wonder if this is an artifact of the difference between British and American usage (D/M/Y versus M/D/Y). Data normalization looks to be a lengthy task after all.
