Convert MDB to DTA

Turn MDB files into DTA files. A Stata 14 file (format 118), which Stata 14 and later open.

Converted in an isolated sandbox on our serversDeleted after 24 hours

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

Stata files from your Access tables.One DTA file per table, ready for Stata 14 and later.

  1. What you get

    Each table in the Access database becomes its own DTA file, named after the table. The files are Stata 14 files (format 118), which Stata 14 and later open.

    Integers, decimals and money become numbers. Yes/no fields become 1 and 0, dates become date-times, and NULL becomes missing.

  2. How columns are stored

    Column names become Stata names of up to 32 letters, digits and underscores. When a name has to change, the original name is kept as the variable label.

    Whole numbers become byte, int or long variables where they fit. Text longer than 2,045 bytes becomes a strL. Dates use the %td format, and other times use %tc.

  3. What is left out

    Access queries, forms and reports are not converted. Only the tables come across. If you need other formats for the same database, see every MDB conversion.

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

Stata Data

Stata datasets.

Extensions
.dta
MIME type
application/x-stata-dta
Kind
Text and data

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

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

Questions.What people ask about MDB to DTA.

01OF 04

Yes. The conversion writes one DTA file per table, named after the table.

Stata 14 and later. The files use format 118.

NULL becomes missing in the DTA file.

No. They are left out, and only the tables are converted.

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