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.
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.
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.
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
Access Database
Microsoft Access databases with several tables inside.
- Extensions
- .mdb .accdb
- MIME type
- application
/x -msaccess - Kind
- Text and data
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.
$ cv convert report.mdb report/ --to parquet$ cv convert report.mdb report/ --to parquetQuestions.What people ask about MDB to PARQUET.
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.