importing codes/values from excel to spss

Posted by E. Bernardo on Oct 18, 2012; 2:50am
URL: http://spssx-discussion.165.s1.nabble.com/importing-codes-values-from-excel-to-spss-tp5715703.html

Dear SPSS Experts,

I have two different files now: Excel and SPSS files. The excel file contains the list of 1500 "city address" with corresponding values/codes(e.g., 1= city1,  2=city2, 3=city3, ....1500=city1500).  Now, I will add the "city address" to my SPSS file. Is there a way to input the codes/values to SPSS without encoding manually the 1500 codes/values?

Your help is highly solicited.

Thank you.

Eins