Export from SPSS to ACCESS (method2)

 

Download as .sps Shows as plain text

 

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
*From syntax, to save an open spss dataset back into MS Access, use a
variation of the following:

* Assume working file is x.sav and is the current open spss dataset
*  Assume SPSS 9 and MS Access 97 and an MDB file exists called newrpt.mdb

SAVE TRANSLATE
 /CONNECT='DSN=MS Access 97'+
 ' Database;DBQ=c:\\temp\\newrpt.mdb;DefaultDir= c:\\temp;
  DriverId=25;FIL=MS Access;MaxBufferSize=512;PageTimeout=5;'
  /TABLE = "x"
  /TYPE = ODBC
  /replace.

The final /replace is optional.

*Posted on 20010123 by JBlaskovic@AOL.COM to SPSSX-L.
Related pages

...

Navigate from here