mdb-to-sqlite

library1.0.2jsnpmunverified

Converts Microsoft Access .mdb files (97-2003) to SQLite databases via a simple CLI command. Stable v1.0.2, no system dependencies, runs on Node.js ≥16. Lightweight and cross-platform, no ODBC or Access installation needed. Converts all tables, normalizes Access types to SQLite types, and provides clear exit codes for automation. Limitations: no .accdb support, no table filtering or custom output paths yet. Active development with planned features.

database

npm install mdb-to-sqlite

github ↗package ↗homepage ↗

INSTALL

IMPORT

SIG · MDB-TO-SQLITE

mdb-to-sqlite

databasejavascriptv1.0.2

harness data pending

Install & Compatibility

Where this runs

No compatibility data collected yet for this library.

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

mdb-to-sqlite

✓ npx mdb-to-sqlite <path-to-file.mdb>

✗ mdb-to-sqlite path/to/file.mdb

Primary usage is as a CLI tool via npx. Running directly as a module import is not supported.

Convert a Microsoft Access .mdb file to SQLite database with one command using npx.

npx mdb-to-sqlite ./example.mdb

Debug

Known issues

gotcha.mdb file must be an Access 97-2003 format. .accdb files (Access 2007+) are NOT supported and will result in an error.

fix

Ensure the input file has .mdb extension and is in the older Access format. Use Access to convert .accdb to .mdb first.

affects: >=1.0

gotchaOLE object fields and embedded images are not fully converted. They may be stored as raw binary data or ignored.

fix

Migrate OLE objects manually or use a different tool that handles them, such as mdb-tools (Linux) or mdbtools.

affects: >=1.0

gotchaExported tables include ALL tables in the .mdb file. There is no option to filter which tables are converted.

fix

If you need to exclude certain tables, consider splitting the .mdb file into multiple files or use an alternative converter.

affects: >=1.0

gotchaCustom output path is not available. SQLite file is always created in the same directory as the input .mdb file.

fix

Copy or move the output .sqlite file after conversion, or run the command from a directory where you want the output.

affects: >=1.0

gotchaBoolean values in Access are stored as 0/1 INTEGER in SQLite, not as actual boolean types. This may require adjustments in queries.

fix

When querying boolean fields, compare with 0 or 1 instead of true/false, or cast to boolean in your application.

affects: >=1.0

Errors

Common errors & fixes

Usage: mdb-to-sqlite <path-to-file.mdb>

No argument provided or the command is called without a file path.

fix

Run the command with a valid .mdb file path: npx mdb-to-sqlite /path/to/file.mdb

Error: File not found: ./does-not-exist.mdb

The specified file path does not exist or is incorrect.

fix

Verify the file path and ensure the file exists. Use absolute or relative path correctly.

Error: Only .mdb files are supported in the current version.

Input file has an extension other than .mdb (e.g., .accdb) or no extension.

fix

Convert .accdb to .mdb using Microsoft Access or a compatible tool, then run the converter.

Upgrade

Version history

1.0.2latest on npm

Audit

Dependencies

No dependency data recorded yet.

Agent activity

5 hits · last 30 days

node

Resources

githubhttps://github.com/MarceloDelgadoDev/mdb-to-sqlite ↗

packagemdb-to-sqlite ↗

homepagehttps://github.com/MarceloDelgadoDev/mdb-to-sqlite#readme ↗