Convert MDB to SQL

Turn MDB files into SQL. A CREATE TABLE statement and INSERT statements in SQLite dialect for every table, with dates written as 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 as a SQL script.Every table comes out as SQL text that SQLite can run.

  1. What you get

    One SQL file. For every table in the database, it holds a CREATE TABLE statement and INSERT statements for the rows, written in SQLite dialect.

    Any SQL tool can read the file or replay it to rebuild the tables.

  2. How values are written

    Dates are written as YYYY-MM-DD hh:mm:ss. Yes/no fields become 1 and 0. Money is written as plain numbers.

  3. What it leaves behind

    Only tables are carried over. Access queries, forms and reports are left out, so anything that lives in them is not in the SQL file.

    The conversion has no options. Both MDB and ACCDB files are accepted.

  4. When it fails

    If the file cannot be parsed, the conversion stops with input_corrupted. No SQL file is produced in that case.

MDB and SQL.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 · SQL

SQL Script

SQL statements as text. A database dump that any SQL tool can read or replay.

Extensions
.sql
MIME type
application/sql
Kind
Text and data

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

terminal
$ cv convert report.mdb report.sql
$ cv convert report.mdb report.sql

Questions.What people ask about MDB to SQL.

01OF 04

Yes. Each table gets a CREATE TABLE statement and INSERT statements for its rows.

SQLite. The statements are written in that dialect.

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

See every MDB conversion for other formats, or every SQL conversion for other ways to produce SQL.

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