mdb-sql
TLDR
Query database
$ mdb-sql [database.mdb]
Execute SQL$ echo "[SELECT * FROM table]" | mdb-sql [database.mdb]
Interactive mode$ mdb-sql -p [database.mdb]
Specify delimiter$ mdb-sql -d [,] [database.mdb]
No headers$ mdb-sql -H [database.mdb]
SYNOPSIS
mdb-sql [options] database
DESCRIPTION
mdb-sql executes SQL queries on Access databases. It provides SQL interface to MDB files.
The tool is part of mdbtools. It supports basic SELECT, INSERT, UPDATE operations.
mdb-sql queries Access databases.
PARAMETERS
DATABASE
Microsoft Access database file.-p
Pretty print output.-d DELIM
Field delimiter.-H
Suppress headers.--help
Display help information.
CAVEATS
Limited SQL support. Part of mdbtools. May not support all Access features.
HISTORY
mdb-sql is part of mdbtools for accessing Microsoft Access databases on Linux/Unix.
SEE ALSO
mdbtools(1), mdb-tables(1), mdb-export(1)
