Convert MDB to PARQUET

Turn MDB files into PARQUET files. One Parquet file per Access table, named after it, with the columns typed as stored: dates as timestamps, yes/no fields as 1 and 0 and money as doubles.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

One Parquet file for each Access table.Each table in the database becomes its own file, with typed columns.

  1. What you get

    One Parquet file per Access table, named after the table. An MDB or ACCDB with several tables gives you several files.

    The columns are typed as they are stored in Access. Dates become timestamps, yes/no fields become 1 and 0, and money becomes doubles.

  2. What it leaves behind

    Access queries, forms and reports are left out. Only the tables are converted, so anything that lives in a query or a report is not in the output.

  3. Working with the files

    Each table is a separate file. To join several Parquet files into one, you can merge PARQUET afterwards.

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

Parquet

The columnar data format of analytics. Compressed, typed and fast to scan.

Extensions
.parquet .pq
MIME type
application/vnd.apache.parquet
Kind
Text and data

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

terminal
$ cv convert report.mdb report/ --to parquet
$ cv convert report.mdb report/ --to parquet

Questions.What people ask about MDB to PARQUET.

01OF 04

Yes. Each Access table becomes one Parquet file, named after the table.

Dates are stored as timestamps. Yes/no fields are stored as 1 and 0.

Money fields become doubles in the Parquet file.

No. Queries, forms and reports are left out. Only the tables are converted.

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