Date:         Thu, 17 Feb 2005 17:17:12 +0100
Reply-To:     fvillamayor-research@ferrergrupo.com
Sender:       "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
From:         Frederic Villamayor <fvillamayor-research@ferrergrupo.com>
Subject:      Re: SPSS to MS Acess 2000
Content-Type: text/plain; charset="iso-8859-1"

Boris,
My experience is not exactly on exporting SPSS data to Access. What I've 
actually done was importing SPSS data to Access by using the ODBC driver. 
This driver is distributed in the SPSS CD-ROM. It was not difficult to do 
it. The basic concepts are that all the SPSS data files must be on the 
same directory (which must be specified when defining your ODBC data 
source), and that each data file will be imported as an Access table. Don' 

sort or filter the data with SQL statements when importing. Better import 
the entire files, and then work with them once they are in Access format. 
You can import the data or you can create Access table linked to an SPSS 
data file.
I'm working with SPSS 11. I don't know if latest versions can directly 
export data to Access, as you want.

Hope this helps.

Frederic


%%%%%%%%%%%%%%%%%%%%%%%%%%%%
Frederic Villamayor
Unitat de Bioestadística
Àrea de Desenvolupament Preclínic
CIDF Ferrer Grupo
Juan de Sada, 32
08028  -  Barcelona
Espanya

E-mail: fvillamayor-research@ferrergrupo.com
Tel: +34 935093236
Fax: +34 934112764
WWW: www.ferrergrupo.com

----------
"Sanity is not statistical"
1984 (George Orwell) 





Boris Ratchev <bratchev@yahoo.com>
Enviado por: "SPSSX(r) Discussion" <SPSSX-L@LISTSERV.UGA.EDU>
17.02.2005 16:54
Por favor, responda a bratchev

 
        Para:   SPSSX-L@LISTSERV.UGA.EDU
        cc: 
        Asunto: [SPSSX-L] SPSS to MS Acess 2000


Dear listserv,

Can anyone share their experience on exporitng data
from SPSS 13.0 to MS Access 2000.

Thanks,

Boris Rachev
Caliber Associates, Inc.



__________________________________
Do you Yahoo!?
Yahoo! Mail - Find what you need with new enhanced search.
http://info.mail.yahoo.com/mail_250