My approach would be to create a Make-Table query in Access, in addition to the numeric field values, also include the lookup table labels for them. Run the query and then import this new table into SPSS. Then do an autorecode on the imported string values derived from the lookup tables. Run frequencies on everything afterwards to be sure these transformations worked as they should.

Variable labels are another matter. Since you have to create a database query to import from Access, you can paste the query syntax and make your variable label modifications there. In v11, the database wizard gives you the option to autorecode alpha values in the database file.

At 13:40 9-16-2002, Wynde Jones wrote: >I am a novice SPSS user and fairly experienced Access user (not >programmer), so for what it's worth... > >As far as I know, I don't think that you can import Access field >descriptions (the equivalent to SPSS variable labels), nor can you import >Access lookup values (what I interpret as the equivalent to SPSS value >labels). My partial solution to this dilemma has been to write syntax for >my most commonly imported variables and apply it to my newly imported file. > >If other Access users have been able to import field descriptions and >lookup values into SPSS, I'd like to know how to do that as well. > >Wynde Jones >Texas Department of Criminal Justice > > >Wynde L. Jones >Research, Evaluation & Development Group >Texas Department of Criminal Justice > > > > > "Judith Jaeger, > Ph.D.,M.P.A." To: SPSSX-L@LISTSERV.UGA.EDU > <jaeger.ju@veriz cc: > on.net> Subject: Re: Importing > Variable and Value labels from Access - Reply > Sent by: > "SPSSX(r) > Discussion" > <SPSSX-L@LISTSER > V.UGA.EDU> > > > 09/16/02 01:26 > PM > Please respond > to "Judith > Jaeger, > Ph.D.,M.P.A." > > ID Number: > > > > > >Thanks very much for replying. However I believe I must have been unclear >in my original question. We have no difficulty exporting ACCESS files into >SPSS. > >The question relates to the fact that the data and 8 character variables >names migrate successfully but the variable labels and value labels do not. >Does anyone know how to preserve variable and value labels when exporting >between file types (and in particular between Access and SPSS.) > >Thanks again for considering this problem! >Judith Jaeger > > > >At 02:27 PM 9/16/2002 -0400, Harding Faulk wrote: > >I'm sure everyone has already told you that this can be done easily. I > >usually export to Excel or DBase then export into SPSS. But I'm sure you > >can export ACCESS or even SQL files as I have done in the past. > >----- Original Message ----- > >From: "Judith Jaeger, Ph.D.,M.P.A." <jaeger.ju@verizon.net> > >Newsgroups: bit.listserv.spssx-l > >To: <SPSSX-L@LISTSERV.UGA.EDU> > >Sent: Monday, September 16, 2002 11:39 AM > >Subject: Importing Variable and Value labels from Access > > > > > > > Dear Listmembers, > > > I'm brand new to the SPSS list, so forgive me if this topic has been > > > addressed already. (In that case I'd appreciate it if someone could >just > > > point me in the right direction). > > > > > > We are using Access to store and manage data for a relatively complex > > > clinical research project. I would like to be able to assign Variable > > > labels and Value Labels within Access that then migrate to SPSS. (We're > > > using ver 9 for Windows). Can this be done? Is this available in a >later > > > version than we now have? > > > > > > I'd appreciate any experiences members of the list might have had in >this > >area. > > > > > > Thanks! > > > Judith Jaeger > > >

---------- Victor