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.

  1. 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.

  2. 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

From · MDB

Access Database

Microsoft Access databases with several tables inside.

Extensions
.mdb .accdb
MIME type
application/x-msaccess
Kind
Text and data
To · XPT

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.

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

Questions.What people ask about MDB to XPT.

01OF 04

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.

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