dannguyen

This example shows basic usage of mdbtools to extract CSV/SQL from Microsoft databases, but also involves a fairly convoluted Bash loop. For a simpler example, go here: Using mdbtools to extract CSV data from the FAA Wildlife Strike Database

Working with Access files from the command line

Use mdbtools: https://github.com/brianb/mdbtools

If you're on a Mac, you can install mdbtools via homebrew:

brew install mdbtools

dannguyen

Using mdbtools to extract CSV data from the FAA Wildlife Strike database (.accdb, Microsoft Access)

These instructions are specifically for OSX and *.nix users who have access to Bash. If you're on Windows...you should probably just use Microsoft Access...

For a more convoluted example of how to use mdbtools to automate the conversion of an Access database, you can see this example I posted with the Florida prisons database (not recommended for Bash novices)

To just get the data as CSV, you can download it from here:

http://stash.compjour.org/samples/faa-wildlife-strikes.zip