Shell script to convert Access DB to SQL - Requires mdbtools

access_to_mysql.sh

#!/bin/bash
TABLES=$(mdb-tables -1 $1)

for t in $TABLES
do
  echo "DROP TABLE IF EXISTS $t;"
done

mdb-schema $1 mysql
for t in $TABLES
do
  mdb-export -D '%Y-%m-%d %H:%M:%S' -I mysql $1 $t
done

I made some adjustments to this script since I've had issues when I ran it

• Table names with spaces
• Values with the ` or ' character
• Values with back slashes
• Large Text values from Access being limited to (255) characters

I wanted to submit a pull request, but I can't do that with gists, so I'll link a gist with the changes here instead.

Edit: Fixed broken link.

@jerryq27 your gist link is dead

@dartmann think i found it https://notes.tomcarlson.com/mdb-to-mysql