Importing SPSS files into Access
DAEB
Mr White, I always convert my SPSS files to DBF and use them in
excel, =
SAS and ACCESS. I think this way has to work. How did yoiu convert the =
files ? Look if you have tryed to open the file while it was opened by =
SPSS. Guilherme.
----------
De: White, Robin HSURC[SMTP:Whi...@SDH.SK.CA]
Enviada em: Quarta-feira, 8 de Outubro de 1997 12:01
Para: SPS...@UGA.CC.UGA.EDU
Assunto: Importing SPSS files into Access
Hi All,
Is there a way to import an SPSS file into Access without going through
Excel? My file is too big for Excel (33,000 records) and I'd like to
avoid splitting the file into several smaller files. Also, saving as a
.dbf file doesn't work either (but I'm not sure why).
Many thanks!
Robin White
Research Officer
HSURC
Saskatoon, SK
Canada
whi...@sdh.sk.ca
David Mark Marso
White, Robin HSURC wrote:
>
> Hi All,
>
> Is there a way to import an SPSS file into Access without going through
> Excel? My file is too big for Excel (33,000 records) and I'd like to
> avoid splitting the file into several smaller files. Also, saving as a
> .dbf file doesn't work either (but I'm not sure why).
>
> Many thanks!
>
> Robin White
> Research Officer
> HSURC
> Saskatoon, SK
> Canada
> whi...@sdh.sk.ca
Robin,
Use SPSS to create a fixed ASCII or TAB delimited file.
I would recommend TAB delimited just in case you end up without
a space delimiting your variables or if you have embedded spaces
in text strings in your data... Hmmm why does this sound familiar ;-)
In fact, in the amount of time it took to write this note, I was
able to Export a 1000000 (one million) case file with 3 string
variables,
set up an Access table (This is the very first Time I have used Access)
and complete the import. The TAB export took about 3 minutes at most.
In menus: File> Save As > Fixed ASCII (.dat)
or
File> Save As > Tab Delimited (.dat)
fill in a name and you are off and ready to go.
Or from Syntax:
*Fixed ASCII*.
WRITE OUTFILE 'filename' / ALL .
EXECUTE.
* Tab delimited *.
SAVE TRANSLATE OUTFILE 'filename' / TYPE=TAB.
Then use IMPORT from Access.
Regards, David Marso