Date: Wed, 23 Jan 2002 09:32:50 -0500
Reply-To: Lisa Montiel <firstname.lastname@example.org>
Sender: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From: Lisa Montiel <email@example.com>
Subject: Re: reading MS ACCESS DB: Does SPSS would read tables with
Content-Type: text/plain; charset="iso-8859-1"
I use Database Capture to import variables from Access tables to SPSS with
no problem. You can choose which variables from each Access table to import
(or all) which was handy for what I wanted to do. The only problem I had was
the difference in variable naming conventions between the two programs so I
had to rename many variables - my variables in Access began with a number
but SPSS wanted it to begin with a letter. Let me know if you need help with
> -----Original Message-----
> From: SPSSX(r) Discussion [mailto:SPSSX-L@LISTSERV.UGA.EDU]On Behalf Of
> McCrea, Pat A EDUC:EX
> Sent: Tuesday, January 22, 2002 6:12 PM
> To: SPSSX-L@LISTSERV.UGA.EDU
> Subject: reading MS ACCESS DB: Does SPSS would read tables with
> replicatio n ids?
> Hello all,
> First, I'd just like to say how much I appreciate all the great advice
> provided by those who respond to questions of this list.
> My question involves SPSS and ACCESS. I don't use ACCESS very often but I
> have been asked to read a series of tables in an ACCESS database
> into SPSS.
> I thought it would be very straightforward to use the Open
> Database feature.
> Most of the tables open without a problem but some seemed to open
> (no error
> messages) but placed no data in the data editor. I went back into the
> ACCESS db and found that there was data in the tables. I then
> exported the
> data from ACCESS to EXCEL and read the data with SPSS which
> worked fine. I
> went back to ACCESS to look at the records in the table which did not move
> across correctly and I found each contained fields which had a type of
> REPLICATION ID. Not knowing what this meant I did a bit of reading but
> nowhere could I find a way to move records containing these fields from
> ACCESS to SPSS. (If I delete the columns in ACCESS, SPSS can
> read the file
> correctly but I do need the keys to link between tables!)
> Is there a way to have SPSS read these keys (and the rest of the data)
> directly from ACCESS (without having to go through EXCEL)?
> PS. The ACCESS data is an export from SQL Server. One day, we may try to
> read the data directly from SQL Server. Will we have the same problem and
> what is the solution?
> Thanks again for your invaluable assistance.
> Pat McCrea
> Data Management and Student Certification, Ministry of Education, PO Box
> 617 Government St, Victoria BC V8W 9H1 (250) 356-2440 fax
> (250) 356-2504