Convert MDB to SQLITE

Turn MDB files into SQLITE. Every table with its rows and column types, with dates stored as text YYYY-MM-DD hh:mm:ss, yes/no fields as 1 and 0 and money as plain numbers.

Converted in an isolated sandbox on our serversDeleted after 24 hours

Drop MDB files on the dialor turn it to pick what to do

An Access database in one SQLite file.Every table comes over with its rows and column types. Queries, forms and reports stay behind.

  1. What you get

    One SQLite file that holds every table from the Access database, with all of its rows. The column types are kept too.

    Some values are stored in a different form. Dates are written as text in the form YYYY-MM-DD hh:mm:ss. Yes/no fields become 1 and 0. Money becomes plain numbers.

  2. What it leaves behind

    Only tables are carried over. Access queries, forms and reports are left out, so anything that lives in those does not appear in the SQLite file.

    Both MDB and ACCDB files are read, and the result is a single file whatever the number of tables.

  3. When a conversion fails

    If the file cannot be parsed, the conversion stops with input_corrupted. This means the database file itself could not be read as an Access database.

MDB and SQLITE.What each format is.

The formats

From · MDB

Access Database

Microsoft Access databases with several tables inside.

Extensions
.mdb .accdb
MIME type
application/x-msaccess
Kind
Text and data
To · SQLITE

SQLite Database

A whole relational database in one file. Tables, indexes and views.

Extensions
.sqlite .sqlite3 .db
MIME type
application/vnd.sqlite3
Kind
Text and data

In your code.The same MDB to SQLITE conversion through the API, for your app or your agent.

terminal
$ cv convert report.mdb report.sqlite
$ cv convert report.mdb report.sqlite

Questions.What people ask about MDB to SQLITE.

01OF 04

Yes. Every table comes over with its rows and column types.

As text in the form YYYY-MM-DD hh:mm:ss.

Yes/no fields are stored as 1 and 0. Money is stored as plain numbers.

No. Only tables are carried over. Queries, forms and reports are left out.

More conversions.Other ways in and out of MDB and SQLITE.