Giter Site home page Giter Site logo

hartl3y94 / mdbtools Goto Github PK

View Code? Open in Web Editor NEW

This project forked from cyberemissary/mdbtools

0.0 0.0 0.0 3.97 MB

MDB Tools - Read Access databases on *nix

Home Page: http://mdbtools.sourceforge.net

License: GNU General Public License v2.0

Makefile 0.73% Shell 1.56% M4 4.24% C 91.77% Lex 0.61% Yacc 1.10%

mdbtools's Introduction

Build Status Build status

Welcome to the exciting world of MDB Tools! MDB Tools is a set of programs to help you extract data from Microsoft Access files in various settings. See the NEWS file for information about the latest release.

Components

The major pieces of MDB Tools are:

libmdb

The core library that allows access to MDB files programatically.

libmdbsql

Builds on libmdb to provide a SQL engine (aka Jet)

utils

Provides command line utilities, including:

Command Description
mdb-ver Prints the version (JET 3 or 4) of an mdb file.
mdb-schema Prints DDL for the specified table.
mdb-export Export table to CSV or SQL formats.
mdb-json Export table to JSON format.
mdb-tables A simple dump of table names to be used with shell scripts.
mdb-count A simple count of number of rows in a table, to be used in shell scripts and ETL pipelines.
mdb-sql A simple SQL engine (also used by ODBC and gmdb).
mdb-queries List and print queries stored in the database.
prcat Prints the catalog table from an mdb file.
prkkd Dump of information about design view data given the offset to it.
prtable Dump of a table definition.
prdata Dump of the data given a table name.
prole Dump of ole columns given a table name and sargs.
mdb-hexdump (in src/extras) Simple hex dump utility that I've been using to look at mdb files.
mdb-array Export data in an MDB database table to a C array.*
mdb-header Generates a C header to be used in exporting mdb data to a C prog.*
mdb-parsecsv Generates a C program given a CSV file made with mdb-export.*

* Deprecated

odbc

An ODBC driver for use with unixODBC or iODBC driver manager. Allows one to use MDB files with PHP for example.

gmdb2

The Gnome MDB File Viewer and debugger. Alpha quality, moved to mdbtools/gmdb2.

License

Files in libmdb, libmdbsql, and libmdbodbc are licensed under LGPL and the utilities and gui program are under the GPL, see COPYING.LIB and COPYING files respectively.

Requirements

First, you must have reasonably current installations of:

If you want to build the SQL engine, you'll need bison (version >= 3.0) or byacc, and flex.

If you want to build the ODBC driver, you'll need unixodbc-dev (version 2.2.10 or above) or iodbc.

If you want to build man pages, you'll need GNU awk.

Installation

Latest version is available at https://github.com/mdbtools/mdbtools

Debian

apt install mdbtools

Homebrew

brew install mdbtools

From source

$ autoreconf -i -f

Then:

$ ./configure

OR for a complete install (requires bison, flex, and unixODBC):

$ ./configure --with-unixodbc=/usr/local

By default, MDB Tools is linked against the copy of GLib returned by pkg-config. You can point to a different GLib installation using the GLIB_CFLAGS and GLIB_LIBS enivornment variables. Or, you can disable GLib entirely with the --disable-glib flag, in which case MDB Tools will use an internal implementation of GLib's functions.

configure can be passed any of the following flags to turn on other capabilities. Note that the options --with-unixodbc and --with-iodbc are mutually exclusive.

--with-unixodbc  specifies the location of the unixODBC driver manager and 
                 causes the unixODBC driver to be built.
--with-iodbc     specifies the location of the iODBC driver manager and 
                 causes the iODBC driver to be built.

A list of general options is available in the INSTALL file, and configure --help will give you the list of mdbtools specific options.

$ make

Once MDB Tools has been compiled, libmdb.[so|a] will be in the src/libmdb directory and the utility programs will be in the src/util directory.

You can then install (to /usr/local by default) by running the following as root:

$ make install

Some systems will also need the ld cache to be updated after installation; You can do that running:

$ ldconfig

Hacking

If you are interested in helping, read the HACKING file for a description of where the code stands and what has been gleened of the file format.

Contact

Please send bug reports to the new github repository. https://github.com/mdbtools/mdbtools/issues

mdbtools's People

Contributors

adamv avatar brianb avatar brjohnsn avatar chatcannon avatar cyberemissary avatar czarkoff avatar danchr avatar davidhicks avatar evanmiller avatar ewenmcneill avatar jahlborn avatar jakob avatar jimmytaker avatar joshuapinter avatar joshuashort avatar jwrdegoede avatar kaukov avatar leecher1337 avatar markrwilliams avatar mcuelenaere avatar mdjnewman avatar mjwoodcock avatar nirgal avatar nyalldawson avatar ockham avatar paulfitz avatar rhurlin avatar rogerswb avatar rutsky avatar samshawsds avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    ๐Ÿ–– Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. ๐Ÿ“Š๐Ÿ“ˆ๐ŸŽ‰

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google โค๏ธ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.