Convert MDB to XPT
Turn MDB files into XPT files. A SAS transport file of version 5, the kind SAS and the FDA read.
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 SAS Transport file for each Access table.Each table in the database becomes its own XPT file, named after the table.
What you get
The conversion gives you one XPT file per Access table, and each file is named after its table. A database with several tables produces several files.
Integers, decimals and money become numbers. Yes/no fields become 1 and 0, and dates become date-times. NULL becomes missing.
What changes or is left out
Access queries, forms and reports are left out. Only the tables are converted.
Column names are cut to 8 letters, digits and underscores. When a name changes, up to 40 characters of the original are kept as the column's label.
Dates are written as DATE9., date-times as DATETIME20. and times as TIME8. Text longer than 200 bytes is cut.
MDB and XPT.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
SAS Transport
SAS transport files, the exchange format regulators accept.
- Extensions
- .xpt
- MIME type
- application
/x -sas -xport - Kind
- Text and data
In your code.The same MDB to XPT conversion through the API, for your app or your agent.
$ cv convert report.mdb report/ --to xpt$ cv convert report.mdb report/ --to xptQuestions.What people ask about MDB to XPT.
Yes. Each Access table becomes one XPT file, named after the table.
They are cut to 8 letters, digits and underscores. If a name is changed, up to 40 characters of the original stay as the label.
No. Access queries, forms and reports are left out. Only the tables are converted.
Not always. Text longer than 200 bytes is cut.