JavaScript library to read data from Access databases. This is a fork of the original mdb-reader. The original library was converted to ESM, which is not compatible with out OSLO-UML-Transformer project since that is written in CommonJS. This fork is a CommonJS version of the original library. There is a conversion script located in the scripts directory that will convert the original library to CommonJS.
Since the conversion script converts the package.json file, this project will not run in its original form. If you want to use the original package.json, which is an ESM package, you can get it from the original library!
As an extra tweak to the original library, the /lib folder is present inside the Github repository. This is to allow the library to be used directly in the OSLO-UML-Transformer. We could also publish the library to NPM, but that would be an extra step which was not needed at this time. When building the project, the postbuild script will run, which will convert the library from an ESM module to CommonJS using esbuild.
Since this is a fork of the 3.0.0 version of mdb-reader, the code should remain runnable for the OSLO-UML-Transformer. If newer versions get released of this package and we want to use them, we will have to merge the upstream changes from the original library into this fork.
npm install https://github.com/Informatievlaanderen/mdb-reader.gitor
yarn add https://github.com/Informatievlaanderen/mdb-reader.git- Access 97 (Jet 3)
- Access 2000, XP and 2003 (Jet 4)
- Access 2010 (ACE14)
- Access 2013 (ACE15)
- Access 2016 (ACE16)
- Access 2019 (ACE17)
- Jet
- Office Agile
- Office RC4 Crypto API
To decrypt databases, this library requires a few dependencies:
browserify-aes: Only imported when running in browsercreate-hash: Only imported when running in browserfast-xml-parser
import { readFileSync } from "fs";
import MDBReader from "mdb-reader";
const buffer = readFileSync("database.mdb");
const reader = new MDBReader(buffer);
reader.getTableNames(); // ['Cats', 'Dogs', 'Cars']
const table = reader.getTable("Cats");
table.getColumnNames(); // ['id', 'name', 'color']
table.getData(); // [{id: 5, name: 'Ashley', color: 'black'}, ...]browser- Running in the browser with parcelto-json- CLI script that accepts a database file name and outputs the data as JSONsveltekit- Running with SvelteKit
class MDBReader {
/**
* @param buffer Buffer of the database.
*/
constructor(
buffer: Buffer,
options?: {
password?: string;
}
);
/**
* Date when the database was created
*/
getCreationDate(): Date | null;
/**
* Database password
*/
getPassword(): string | null;
/**
* Default sort order
*/
getDefaultSortOrder(): Readonly<SortOrder>;
/**
* Returns an array of table names.
*
* @param normalTables Includes user tables.
* @param systemTables Includes system tables.
* @param linkedTables Includes linked tables.
*/
getTableNames({
normalTables,
systemTables,
linkedTables,
}?: {
normalTables: boolean;
systemTables: boolean;
linkedTables: boolean;
}): string[];
/**
* Returns a table by its name.
*
* @param name Name of the table. Case sensitive.
*/
getTable(name: string): Table;
}class Table {
/**
* Name of the table
*/
readonly name: string,
/**
* Number of rows.
*/
readonly rowCount: number;
/**
* Number of columns.
*/
readonly columnCount: number;
/**
* Returns an ordered array of all column definitions.
*/
getColumns(): Column[];
/**
* Returns a column definition by its name.
*
* @param name Name of the column. Case sensitive.
*/
getColumn(name: string): Column;
/**
* Returns an ordered array of all column names.
*/
getColumnNames(): string[];
/**
* Returns data from the table.
*
* @param columns Columns to be returned. Defaults to all columns.
* @param rowOffset Index of the first row to be returned. 0-based. Defaults to 0.
* @param rowLimit Maximum number of rows to be returned. Defaults to Infinity.
*/
getData<TRow extends {
[column in TColumn]: Value;
TColumn extends string = string;
}>(options?: {
columns?: ReadonlyArray<TColumn>;
rowOffset?: number;
rowLimit?: number;
}): TRow[];
}interface Column {
/**
* Name of the table
*/
name: string;
/**
* Type of the table
*/
type: ColumnType;
size: number;
fixedLength: boolean;
nullable: boolean;
autoLong: boolean;
autoUUID: boolean;
/**
* Only exists if type = 'numeric'
*/
precision?: number;
/**
* Only exists if type = 'numeric'
*/
scale?: number;
}The data types returned by Table.getData() depends on the column type. Null values are always returned as null.
| Column Type | JavaScript Type |
|---|---|
| bigint | bigint |
| binary | Buffer |
| boolean | boolean |
| byte | number |
| complex | number |
| currency | string |
| datetime | Date |
| datetimeextended | string |
| double | number |
| float | number |
| integer | number |
| long | number |
| memo | string |
| numeric | string |
| ole | Buffer |
| repid | string |
| text | string |
To build the library, first install the dependencies, then run npm run build for a single build or npm run watch for automatic rebuilds. There is a postbuild script that will run automatically after the build and does the conversion to CommonJS.
npm install
npm run buildTo run the tests, first install the dependencies, then run npm test. Watch mode can be started with npm test -- --watch.
npm install
npm testSet of applications to read and write Access files, written in C. Main source of knowledge about the file structure and algorithms to extract data from it.
Java library to read and write Access files. It inspired the interface of this library. The databases used for testing are copied from the repository.