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