Convert MDB to SAV

Turn MDB files into SAV files. An SPSS file in UTF-8.

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 SPSS file for each Access table.Each table becomes its own SAV file in UTF-8, named after the table.

  1. What you get

    One SAV file per table in the Access database, and each file is named after its table. The text is written in UTF-8.

    Integers, decimals and money become numbers. Yes/no fields become 1 and 0, and dates become date-times. NULL becomes system-missing, so empty cells stay marked as missing in SPSS.

  2. How names and dates change

    Column names become SPSS names of up to 64 bytes. When a name has to change, the original name is kept as the variable label, so you can still see what the column was called in Access.

    Dates are written as DATE11, date-times as DATETIME20 and times as TIME8.

  3. What is left out

    Access queries, forms and reports are not converted. Only the tables are.

    Text longer than 32,767 bytes is cut. Anything past that length is not in the SAV file.

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

SPSS Data

SPSS data files with variable labels and value labels.

Extensions
.sav .zsav
MIME type
application/x-spss-sav
Kind
Text and data

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

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

Questions.What people ask about MDB to SAV.

01OF 04

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

NULL becomes system-missing in the SPSS file.

Column names become SPSS names of up to 64 bytes. A changed name keeps the original as its variable label.

No. Queries, forms and reports are left out. Only the tables are written to SAV files.

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