Dump MS Access data from Ubuntu

The mdbtools package for Ubuntu Jaunty includes a command called mdb-export.  This allows you to dump the contents of tblName from database.mdb to STDOUT in CSV format like this:

mdb-export database.mdb tblName

Output redirection to capture the output in a file is also supported (not that that’s a feature of the app, as you know):

mdb-export sample.mdb tblFoo > capture.txt

Leave a Reply

Your email address will not be published. Required fields are marked *