Export from SPSS to ACCESS

Solution ID:	 	100007071	
Product:	 	SPSS Base 	

Title:
Using SPSS 9.0 to create an Access 97 table. 
Description:
Q. 
I'd like to be able to save out an SPSS system file as an Access 97 table. Can I? 
A. 
SPSS 9.0 for Windows can save data into an Access 97 database using SAVE TRANSLATE. First, make sure that you can bring in an Access file using Database Capture. If you can, then your Access driver is functioning correctly, and you will be able to write out an Access file. 
Then, create an empty database in Access 97. SPSS will write the data into this database. 
In SPSS, open a Syntax Window. Then type in the following syntax: 
SAVE TRANSLATE TYPE=ODBC 
/connect="DSN=MS Access 97 Database;UID=ADMIN;PWD=; "+ 
"DBQ=C:\\My Documents\\Empty.mdb;DefaultDir="+ 
"C:\\My Documents;DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;" 
/table="TEMP9" 
/unselect=retain 
/replace 
/map. 
Change "C:\\My Documents\\Empty.mdb" to the path and file name of the empty Access 97 database you created. Then change DefaultDir=C:\\My Documents to the name of the directory where the empty Access 97 database is located. If your database is password protected, add the password after PWD=, and change UID=ADMIN to the name of the user. 
Then run the syntax. You may encounter the following error in your output: 
>Warning # 6475 
>Failed to set the SQL_AUTOCOMMIT mode to off - might give a problem to roll 
>back in the event of any failure. 

This error is normal, and will not affect the writing of the data. Depending on the size of your file, it may take a significant amount of time to write out the file. You should see "Running SAVE..." in the status bar and the case counter will run during the save. Once the save is complete, a summary table of what data and variables were written will appear in the output. 
Created on: 07/21/1999