Importing value labels from Access into SPSS

Steve Simon

2005-05-24

Categories: Blog post Tags: Data management

[StATS]: Importing value labels from Access into SPSS (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.

This page was written by Steve Simon while working at Children's Mercy Hospital. Although I do not hold the copyright for this material, I am reproducing it here as a service, as it is no longer available on the Children's Mercy Hospital website. Need more information? I have a page with general help resources. You can also browse for pages similar to this one at Category: Data management.

management](../category/DataManagement.html). for pages similar to this one at [Category: Data with general help resources. You can also browse Children's Mercy Hospital website. Need more information? I have a page reproducing it here as a service, as it is no longer available on the Hospital. Although I do not hold the copyright for this material, I am This page was written by Steve Simon while working at Children's Mercy