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