MDB Tools
MDB Tools is a set of command line utilities that can be used to read mdb format (Microsoft Access) database files on Linux.
It also comes with a gtk based graphical frontend tool called Gmdb (Gnome MDB Viewer) that can be used to read the table structure and data quickly and easily.
More information can be found at the project website:
https://github.com/mdbtools/mdbtools
On Ubuntu or Linux Mint it can be installed from default repositories:
$ sudo apt-get install mdbtools
If you want a gui tool then use MDB Tools Gmdb program from the following github project:
https://github.com/mdbtools/gmdb2The package is not available in the ubuntu repositories, so you need to compile it for ubuntu or any other distro.
Deprecated:
Earlier there was a package named mdbtools-gmdb that could install everything, but its no more available.
$ sudo apt-get install mdbtools-gmdb
$ gmdb2
Sir,
After installing
$sudo apt-get install mdbtools-gmdb
the MDBTools is not working Showing
“could not find driver ”
here is my php code —>
$database=”/opt/lampp/elibdata/database1.mdb”;
$driver = “MDBTools”;
try {
//$dbh = new PDO(“odbc:DSN=MS Access Database;DBq=$database;”);
$dbh = new PDO(“MDBTools:Driver={Microsoft Access Driver (*.mdb, *.accdb)};DBq=$database;”);
//$dbh = new PDO(“pgsql:host=localhost;dbname=”,$database,””,””);
//$dbh = new PDO(“odbc:Driver=$driver;DBQ=$database”, “”, “”);
$dbh->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$sql = “SELECT * FROM Admc”;
$STH = $dbh->query($sql);
$STH->setFetchMode(PDO::FETCH_ASSOC);
}
catch(PDOException $e) {
echo $e->getMessage().”n”;
exit;
}
#close the connection
$dbh = null;
Please guide me in this matter.
Thankx in Advance.
MNG