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

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