codenamev
11/1/2013 - 6:05 AM

Ruby script to convert .mdb db file into .csv

Ruby script to convert .mdb db file into .csv

# Export data from Microsoft Access .mdb database into .csv files
# using  https://github.com/brianb/mdbtools 
# Install with homebrew - "brew install mdbtools"

class ConverterScript
  tables = `mdb-tables -d , your_db_name.mdb`.chop.split(",")

  tables.each do |table|
    exists = system("mdb-export your_db_name.mdb '#{table}'")
    `mdb-export your_db_name.mdb '#{table}' > #{table.gsub(" ", "_")}.csv` if exists
  end
end