A quick script that converts a Ms Access database to sql insert files

access_dump.sh

#!/bin/bash
if [ -z "$1" ]
then
    echo "You need to specify the database file. Eg.: ./access_dump.sh my-database.mdb"
    echo ""
    echo "Please make sure that you have mdbtools installed on your system: 'sudo apt install mdbtools'"
    exit 1
fi

DB="$1"
TABLES="$(mdb-tables $DB)"
TABLES=$(echo $TABLES | tr " " "\n")

for TABLE in $TABLES
do
    echo "Exporting table: $TABLE"
    $(mdb-export -I mysql $DB $TABLE > $TABLE.sql)
done