View read and export Access mdb on Linux or WSL

less than 1 minute read

Source found here.

Working with mdb and ses file extensions.

file="filename.ses"
mdb-tables -1 "$file"
tablewanted=( customFields settings ranks teamscores contests results )
for value in "${tablewanted[@]}"; do mdb-export -d \\t "$file" $value > "${value}.csv"; done

Create an alias in bashrc:

nano ~/.bashrc
# add this line: alias sesextract='tablewanted=( customFields ranks teamscores contests results settings );for file in *.ses; do mdb-tables -1 "$file";for value in "${tablewanted[@]}"; do mdb-export -d \\t "$file" $value > "${value}.csv"; done;done'
# save it 
source ~/.bashrc
sesextract