MDB Tools

Description

The MDB Tools project is a effort to document the MDB file format used in Microsoft’s Access database package, and to provide a set of tools and applications to make that data available on other platforms.

Specifically, MDB Tools includes programs to export schema and data to other databases such as MySQL, Oracle, Sybase, PostgreSQL, and others.

In short, MDB Tools is a set of programs to help you use Microsoft Access file in various settings.

Usage

Options

 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 format.
 mdb-tables   --      a simple dump of table names to be used with shell
                      scripts
 mdb-header   --      generates a C header to be used in exporting mdb
                      data to a C prog.
 mdb-parsecvs --      generates a C program given a CSV file made with

Some Example

We have a file namely Books.mdb

cyborg@cyborg:~$ mdb-export -H Books.mdb Books
12,1,"Tony DeSoto and the Crystal Egg","07/01/01 00:00:00","Very good","06/22/01 00:00:00"
13,2,"Hunt for Red October","01/01/95 00:00:00","fair","06/22/01 00:00:00"
14,3,"A Mid-Summer Nights Dream","06/06/95 00:00:00","a little dated","06/22/01 00:00:00"
15,1,"The Girl Who Would Be Wizard","09/01/01 00:00:00","unknown","06/25/01 00:00:00"
16,2,"Patriot Games","01/01/97 00:00:00","Not as good as Red October, but readable","06/25/01 00:00:00"

cyborg@cyborg:~$ mdb-ver Books.mdb 
JET3

cyborg@cyborg:~$ mdb-schema Books.mdb 
-- ----------------------------------------------------------
-- MDB Tools - A library for reading MS Access database files
-- Copyright (C) 2000-2011 Brian Bruns and others.
-- Files in libmdb are licensed under LGPL and the utilities under
-- the GPL, see COPYING.LIB and COPYING files respectively.
-- Check out http://mdbtools.sourceforge.net
-- ----------------------------------------------------------

-- That file uses encoding UTF-8

CREATE TABLE [Authors]
 (
	[AuID]			Long Integer, 
	[Author]			Text (50), 
	[Sequence]			Long Integer, 
	[Current]			Boolean NOT NULL
);

CREATE TABLE [Books]
 (
	[BookID]			Long Integer, 
	[Author]			Long Integer, 
	[Title]			Text (50), 
	[DatePublished]			DateTime, 
	[Comments]			Text (50), 
	[LastRead]			DateTime
);


cyborg@cyborg:~$ mdb-tables Books.mdb 
Authors Books 


cyborg@cyborg:~$ mdb-parsecsv Books.mdb 
count = 49

cyborg@cyborg:~$ mdb-hexdump Books.mdb 
page num 0
-- Page 0x0000 (0) --
000000  00 01 00 00 53 74 61 6e 64 61 72 64 20 4a 65 74   |....Standard Jet|
000010  20 44 42 00 00 00 00 00 b5 6e 03 62 60 09 c2 55   | DB......n.b`..U|
000020  e9 a9 67 72 40 3f 00 9c 7e 9f 90 ff 85 9a 31 c5   |[email protected]?..~.....1.|
000030  79 ba ed 30 bc df cc 9d 63 d9 ed c7 9f 46 fb 8a   |y..0....c....F..|
000040  bc 4e 86 fb ec 37 5d 44 9c fa c6 5e 28 e6 13 b6   |.N...7]D...^(...|
000050  8a 60 54 94 7b 36 1f 75 df b1 77 f4 13 43 cf af   |.`T.{6.u..w..C..|
000060  b1 33 34 61 79 5b 92 b5 7c 2a 05 f1 7c 99 01 1b   |.34ay[..|*..|...|
000070  98 fd 12 4f 4a 94 6c 3e 60 26 5f 95 f8 d0 89 24   |...OJ.l>`&_....$|
000080  85 67 c6 1f 27 44 d2 ee cf 65 ed ff 07 c7 46 a1   |.g..'D...e....F.|
000090  78 16 0c ed e9 2d 00 00 00 00 00 00 00 00 00 00   |x....-..........|
0000a0  00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00   |................|



		
	
	
0 Comments

Leave a reply

CONTACT US

We're are building as a community and a team. Be a part of it.

Sending

©2017 Ztrela Knowledge Solutions Pvt. Ltd

Log in with your credentials

Forgot your details?