Importing value labels from Access into SPSS

*Blog post
Year 2005
Being updated
Data management
Author

Steve Simon

Published

May 24, 2005

Someone asked about importing data from Access into SPSS. The Access file has value labels (e.g., 1=Male, 2=Female, 3=Missing) and wanted to know if there was any<U+FFFD> way to get this information into SPSS.

You cannot easily import value labels into SPSS, as far as I know. One workaround is to use a join in Access to link the table that has the number codes to the table that has the labels. Then export that join into SPSS. You will get a column of data with the number codes and a second column of data with the value labels.

You can also browse for pages similar to this one at Category: Data management.

Earlier versions are here and here.